/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

6 votes128 views2 answers
Can't connect to local mysql server through socket
SQL
0 vote260 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
7 votes128 views1 answer
Mysql iif
SQL
7 votes124 views2 answers
What is sql clause
SQL
0 vote121 views1 answer
Why we have to set the password for my sql server
SQL
1 vote157 views2 answers
Install sql server management studio ubuntu
SQL
0 vote125 views1 answer
Oracle db timestamp auto add
SQL
1 vote142 views1 answer
Mariadb.service: main process exited, code=exited, status=1/failure
SQL
0 vote137 views1 answer
How to access to mysql without root
SQL
-3 votes122 views2 answers
How to enable mysql authentication on ubuntu 18.04
SQL