/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 vote190 views1 answer
How to change null display in psql
SQL
1 vote197 views1 answer
Plsql code for deleting a row from nested table in oracle
SQL
6 votes2.2K views1 answer
Sql select second max
SQL
7 votes221 views2 answers
Where keyword sql
SQL
0 vote274 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
6 votes232 views1 answer
T-sql test if table exists
SQL
2 votes205 views1 answer
Mysql set value as null
SQL
0 vote251 views1 answer
What is default mysql database password in linux
SQL
1 vote193 views1 answer
Truncate left characters mysql
SQL
1 vote193 views1 answer
Python escape mysql
SQL