/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

1 vote166 views1 answer
Oracle start job
SQL
1 vote176 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
1 vote177 views2 answers
Check if word is in column sql
SQL
0 vote206 views1 answer
Sql multiple into
SQL
8 votes225 views2 answers
Change name of colum in sql table
SQL
1 vote218 views1 answer
Postgresql where datetrunc month and year equal
SQL
0 vote169 views1 answer
Mysql procedure between two tables
SQL
0 vote165 views1 answer
Compare subqueries oracle
SQL
0 vote198 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
0 vote183 views1 answer
Create tables from xsd to sql server database c#
SQL