/SQL/Left join vs inner join performance

Left join vs inner join performance

CREATE TABLE #Test1
(
    ID int NOT NULL PRIMARY KEY,
    Name varchar(50) NOT NULL
)
INSERT #Test1 (ID, Name) VALUES (1, 'One')
INSERT #Test1 (ID, Name) VALUES (2, 'Two')
INSERT #Test1 (ID, Name) VALUES (3, 'Three')
INSERT #Test1 (ID, Name) VALUES (4, 'Four')
INSERT #Test1 (ID, Name) VALUES (5, 'Five')

CREATE TABLE #Test2
(
    ID int NOT NULL PRIMARY KEY,
    Name varchar(50) NOT NULL
)
INSERT #Test2 (ID, Name) VALUES (1, 'One')
INSERT #Test2 (ID, Name) VALUES (2, 'Two')
INSERT #Test2 (ID, Name) VALUES (3, 'Three')
INSERT #Test2 (ID, Name) VALUES (4, 'Four')
INSERT #Test2 (ID, Name) VALUES (5, 'Five')

SELECT *
FROM #Test1 t1
INNER JOIN #Test2 t2
ON t2.Name = t1.Name

SELECT *
FROM #Test1 t1
LEFT JOIN #Test2 t2
ON t2.Name = t1.Name

DROP TABLE #Test1
DROP TABLE #Test2

Source: stackoverflow.com

Similar codes

0 vote316 views1 answer
A network or instance-specific error sql server
SQL
0 vote319 views1 answer
Grepper sql workbench download
SQL
1 vote311 views1 answer
Not exists mysql
SQL
1 vote335 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote334 views2 answers
Imageview setimageresource null
SQL
2 votes330 views1 answer
Power query concatenate
SQL
0 vote325 views2 answers
How to create a table from another table in sql derby
SQL
0 vote285 views1 answer
Plsql trigger insert update
SQL
-1 vote365 views1 answer
Add 10 to all numbers in a column sql
SQL
0 vote350 views1 answer
Postgresql like
SQL