/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

28 votes303 views4 answers
Show tables mysql
SQL
6 votes337 views3 answers
Create database mysql utf8
SQL
1 vote284 views1 answer
How to print longest name in sql
SQL
1 vote286 views1 answer
Postgres get timestamp
SQL
0 vote322 views1 answer
How to remove quotes from a string in ssis load file
SQL
0 vote294 views1 answer
Connect postgresql using a connection string
SQL
6 votes269 views2 answers
Spring data jpa application.properties mysql
SQL
28 votes347 views6 answers
Sql update
SQL
5 votes329 views1 answer
Sql table columns
SQL
0 vote319 views1 answer
Oracle tablespace autoextend
SQL