/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

33 votes210 views2 answers
Postgres how to add field created at
SQL
2 votes215 views1 answer
Q operator in sql
SQL
2 votes210 views1 answer
Sqlite insert if not exists
SQL
12 votes222 views1 answer
Script to add new column in table sql
SQL
51 votes345 views6 answers
Opera gx
SQL
0 vote217 views1 answer
Mariadb used space
SQL
0 vote228 views1 answer
Object of class mysqli_result could not be converted to string
SQL
16 votes221 views4 answers
Find duplicates mysql
SQL
-1 vote213 views1 answer
Io
SQL
0 vote206 views1 answer
What does the -p flag do in mysql cli
SQL