/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

2 votes154 views1 answer
SQL IF ELSE
SQL
3 votes165 views2 answers
Create schema postgres
SQL
14 votes161 views2 answers
Install mysqldump
SQL
46 votes229 views4 answers
Create column sql
SQL
1 vote141 views1 answer
Select from one table where not on the other
SQL
0 vote186 views1 answer
Grant privileges mysql to database 1064
SQL
1 vote145 views2 answers
Mysql trim whitespace
SQL
0 vote167 views1 answer
Make parameters nullable in sql server
SQL
0 vote165 views1 answer
Mysql config address
SQL
1 vote161 views1 answer
Isnull sql server
SQL