/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 vote222 views1 answer
Update mysql from paypal shopping cart and ipn
SQL
0 vote203 views1 answer
Mysql delete from where like
SQL
11 votes202 views3 answers
Sql line numbers
SQL
-2 votes186 views1 answer
Use of where in left join in mysql
SQL
0 vote223 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote234 views1 answer
Check database restore status sql script
SQL
1 vote274 views1 answer
Mysql is odd
SQL
10 votes226 views4 answers
Else if mysql
SQL
0 vote180 views1 answer
Eliminar ultimo carcacter mysql
SQL
2 votes239 views1 answer
Select a certain number of entries from select mysql
SQL