/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 vote183 views1 answer
Mysql dump everythign
SQL
1 vote187 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote183 views1 answer
How to tell if i have lactose intolerance
SQL
6 votes163 views1 answer
Oracle trigger after connect
SQL
0 vote182 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
0 vote174 views1 answer
Update set with inner join oracle
SQL
5 votes185 views2 answers
Create table mysql example auto_increment
SQL
2 votes183 views1 answer
Sql OR
SQL
0 vote183 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
2 votes186 views1 answer
How to delete all duplicate items in mysql
SQL