/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

12 votes197 views4 answers
Mysql version query
SQL
10 votes142 views2 answers
Django mysql
SQL
3 votes187 views1 answer
Only join in sql
SQL
13 votes192 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote217 views1 answer
Unique element in sql
SQL
8 votes207 views10 answers
Sql
SQL
0 vote187 views1 answer
Mysql concat and use as where column
SQL
244 votes489 views14 answers
Sql n insert
SQL
-1 vote193 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote240 views1 answer
Error code 1215 cannot add foreign key constraint
SQL