/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

25 votes190 views6 answers
Change column name mysql
SQL
3 votes112 views3 answers
Create table in microsoft sql server
SQL
0 vote116 views1 answer
Drop CHECK constraint sql
SQL
1 vote106 views1 answer
Primary key with prefix sql
SQL
0 vote111 views1 answer
Mysql count number of occurrences in a column
SQL
5 votes123 views1 answer
How to get all table names in sql query
SQL
0 vote113 views1 answer
Less than date query sqlachemy
SQL
2 votes100 views2 answers
Join update query in sql
SQL
0 vote97 views1 answer
Get who is hired in month in sql
SQL
0 vote158 views1 answer
Sql server system messeges
SQL