/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 vote317 views1 answer
Does insert into overwrite sql
SQL
0 vote300 views1 answer
What is mysql_pconnect
SQL
16 votes309 views2 answers
Oracle ddl
SQL
3 votes326 views1 answer
Oracle APEX elapsed time
SQL
1 vote297 views1 answer
Postgresql filter on
SQL
0 vote287 views1 answer
Downgrading sql localdb visual studio
SQL
10 votes269 views1 answer
Oracle view dependencies
SQL
0 vote298 views1 answer
Mql5 list all available symbols
SQL
0 vote311 views1 answer
Sql #region
SQL
0 vote309 views2 answers
Demmarrer un service mysql teminal cmd
SQL