/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 vote146 views1 answer
Which lock mode is not available in sql
SQL
0 vote141 views1 answer
Oracle last connection
SQL
0 vote156 views1 answer
Vbscript clean up ADODB.Recordset
SQL
0 vote149 views1 answer
Mysql root permission denied lost
SQL
0 vote188 views1 answer
Mysql show schema
SQL
2 votes161 views1 answer
Install postgresql centos 5
SQL
6 votes134 views5 answers
Alter table oracle
SQL
0 vote156 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
0 vote158 views1 answer
Sql last 3 rows
SQL
0 vote228 views1 answer
Install ms sql server management studio
SQL