/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

1 vote201 views1 answer
Alter table column size oracle
SQL
0 vote183 views1 answer
Pl sql turn off variable substitution
SQL
1 vote205 views1 answer
Mysql select row max date
SQL
36 votes254 views6 answers
Change column data type sql
SQL
0 vote151 views1 answer
Deleted table in sql trigger
SQL
17 votes228 views1 answer
Selecting name that contain certain word in sql
SQL
0 vote147 views1 answer
Expose db in virtualbox
SQL
0 vote209 views1 answer
How to check database engine in mysql
SQL
0 vote180 views1 answer
Sql cross apply vs join
SQL
0 vote196 views1 answer
Window function to forward fill
SQL