/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

23 votes361 views2 answers
Query to delete a database in mysql
SQL
1 vote361 views1 answer
Jooq convert using gbk
SQL
5 votes396 views1 answer
Oracle source query
SQL
1 vote347 views1 answer
Sql myisam vs innodb
SQL
5 votes346 views1 answer
Oracle ORA-00054 origin
SQL
1 vote344 views2 answers
Sql groub by count
SQL
1 vote370 views1 answer
Group_concat order by
SQL
0 vote356 views1 answer
Sql trying to delete database in use
SQL
0 vote347 views1 answer
Reset keys in sql
SQL
0 vote363 views1 answer
Express api ith mysql data
SQL