/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

50 votes359 views6 answers
Sql duplicate rows
SQL
0 vote269 views1 answer
Postgresql create table default value timestamp
SQL
0 vote283 views3 answers
Find below average salary in sql
SQL
12 votes292 views2 answers
Update column data type postgres
SQL
12 votes289 views5 answers
Sql merge
SQL
0 vote280 views1 answer
Mysql show create db
SQL
0 vote355 views1 answer
Python get backup of sql
SQL
1 vote324 views1 answer
How to see logical reads in sql server
SQL
0 vote298 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote238 views1 answer
Mysqli or pdo
SQL