/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 vote369 views1 answer
Set engine to innodb
SQL
9 votes358 views2 answers
Sql limit to 5 results
SQL
0 vote333 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote349 views1 answer
Mysql select field if condition
SQL
0 vote341 views1 answer
Java input type sql date
SQL
0 vote348 views2 answers
Sqlite unix timestamp
SQL
1 vote297 views1 answer
Postgres grant read only access to database
SQL
0 vote354 views2 answers
Cambiar nombre tabla mysql
SQL
2 votes390 views3 answers
Xampp mysql database not starting
SQL
7 votes338 views1 answer
Minecraft forge server host
SQL