/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 votes135 views3 answers
Oracle all dates between two dates
SQL
1 vote130 views1 answer
GROUP BY clause; this is incompati
SQL
25 votes148 views6 answers
How to change column name in mysql
SQL
0 vote136 views1 answer
Sql count null values in all columns
SQL
19 votes133 views6 answers
Laravel sql query
SQL
0 vote150 views1 answer
Play framework connection via windows sql server
SQL
0 vote92 views1 answer
Check if due date is less than todays date sql
SQL
0 vote134 views1 answer
Mysql shell ERROR: Not connected.
SQL
0 vote157 views1 answer
This week mysql
SQL
5 votes153 views3 answers
Select tables from mysql database
SQL