/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

-2 votes224 views3 answers
Oracle tablespace usage
SQL
1 vote229 views3 answers
Showing all columns in an sqlite table
SQL
0 vote226 views1 answer
Tsql cmd exec script from file
SQL
0 vote227 views1 answer
Connect to ssms with python
SQL
1 vote227 views2 answers
Change table name phpmyadmin
SQL
0 vote177 views1 answer
Update sql join multiple tables
SQL
1 vote227 views1 answer
Join to find results not in another table
SQL
0 vote220 views1 answer
Sql get table last modified time
SQL
-2 votes234 views1 answer
No module named '_sqlite3
SQL
16 votes263 views1 answer
Sqlserver add column to table
SQL