/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

22 votes276 views4 answers
Mysql date format
SQL
0 vote295 views1 answer
Enable outgoing remote MySQL access
SQL
1 vote259 views1 answer
Sql group by error
SQL
0 vote291 views1 answer
Cross apply top for each row t1
SQL
-1 vote274 views1 answer
What is in operator
SQL
2 votes281 views1 answer
SQL IF ELSE
SQL
4 votes314 views1 answer
How to drop a database in sql server when it is in use
SQL
0 vote273 views1 answer
Add timestamp column to existing table ms sql server
SQL
1 vote270 views1 answer
Sqlite check if row exists
SQL
0 vote454 views1 answer
Sql change a colum to unique
SQL