/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 vote279 views1 answer
How to run mysql in git bash
SQL
13 votes299 views3 answers
Mysqldump structure only
SQL
2 votes289 views2 answers
Create empty table from existing table
SQL
1 vote547 views1 answer
Athena query timestamp greater than
SQL
0 vote283 views2 answers
Functions with parameters SQL
SQL
15 votes251 views2 answers
How to drop database name in postgresql
SQL
0 vote333 views1 answer
Sql '=' cannot be applied to date varchar(10) athena
SQL
0 vote298 views2 answers
How to get max from each department in sql
SQL
0 vote281 views1 answer
Enable outgoing remote MySQL access
SQL
5 votes246 views1 answer
Oracle list packages
SQL