/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

3 votes192 views2 answers
Search text in all sql server stored procedure
SQL
0 vote161 views1 answer
Postgresql subquery
SQL
4 votes167 views3 answers
Create database in mySQL
SQL
1 vote232 views1 answer
Hangfire clear all jobs
SQL
1 vote175 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
5 votes182 views2 answers
Add column postgres with default value
SQL
3 votes169 views2 answers
Oracle sql drop sequence
SQL
0 vote179 views1 answer
Xampp increame mysql speed
SQL
0 vote174 views1 answer
Incorrect string value: '\xC4\x81ne' for column
SQL
0 vote195 views1 answer
Mysql milliseconds
SQL