/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 vote126 views3 answers
Compute age mysql
SQL
0 vote81 views1 answer
Mysql select top 2
SQL
1 vote110 views1 answer
Alter add syntax
SQL
1 vote118 views1 answer
Snowflake rename column name
SQL
0 vote112 views2 answers
How to check if sqlite table exists in nodejs
SQL
1 vote131 views1 answer
Set id count mysql
SQL
0 vote125 views1 answer
Oracle to_number
SQL
0 vote125 views2 answers
Sql query in dax power bi
SQL
1 vote132 views2 answers
Mysql grant all privileges on *.* to 'root'@' ' identified by
SQL
0 vote122 views1 answer
View to table sql
SQL