/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 vote334 views1 answer
Add super privilege mysql
SQL
0 vote304 views1 answer
Dapper : operator does not exist: integer = integer[]'
SQL
1 vote303 views4 answers
Alter schema sql
SQL
0 vote297 views2 answers
Postgresql display subquery as json
SQL
3 votes314 views2 answers
MySQL query to get column names
SQL
0 vote316 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
0 vote299 views1 answer
Synapse sql table set pk
SQL
0 vote335 views1 answer
Postgresql custom order by
SQL
0 vote318 views2 answers
Mysql set foreign_key_checks=0
SQL
0 vote324 views1 answer
Mysql default tls v1.3 ciphersuites
SQL