/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 vote193 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
2 votes214 views1 answer
Datefromparts mssql
SQL
4 votes167 views1 answer
SQL order random
SQL
-1 vote181 views1 answer
Spring boot mysql connection properties
SQL
0 vote266 views1 answer
Show mysql account privilleges
SQL
0 vote189 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote205 views1 answer
Pl sql search in all packages
SQL
0 vote169 views1 answer
Select in select sql
SQL
13 votes166 views2 answers
Display users in mysql
SQL
0 vote164 views1 answer
Case insensitive sql
SQL