/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 vote145 views1 answer
Wordpress sql change site url
SQL
0 vote134 views1 answer
Pgsql is not permitted to log in
SQL
19 votes166 views4 answers
Can't connect to local MySQL server through socket '/tmp/mysql.sock'
SQL
1 vote148 views1 answer
Moodle query first user access
SQL
0 vote147 views1 answer
Drop view in mysql
SQL
11 votes192 views2 answers
You are using safe update mode
SQL
0 vote136 views1 answer
Drop constraint in ms sql
SQL
0 vote160 views1 answer
Repeatable read trong sql server
SQL
1 vote143 views1 answer
Sql server epoch to datetime
SQL
1 vote118 views1 answer
Oracle compile schema
SQL