/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 vote359 views1 answer
Joins vs includes
SQL
0 vote363 views1 answer
Mysql not defined
SQL
0 vote378 views1 answer
Like sql for second letter of the family name
SQL
5 votes375 views1 answer
Dbms_metadata.get_ddl table
SQL
1 vote367 views1 answer
Altering the column name in MySQL to have a default value
SQL
2 votes369 views2 answers
How to rename column name in sql server using query
SQL
24 votes360 views5 answers
Sql server insert into select
SQL
18 votes355 views6 answers
Create table mysql
SQL
0 vote365 views1 answer
Mysql milliseconds
SQL
1 vote468 views2 answers
Begin transaction sql
SQL