/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 views2 answers
Sql max count
SQL
0 vote353 views1 answer
Oracle for loop on list
SQL
0 vote329 views2 answers
How to list all values of a column that start with a letter in sql
SQL
1 vote316 views1 answer
Input in mysql
SQL
6 votes380 views2 answers
Foreign key sqlite3 python
SQL
1 vote346 views1 answer
Mysql not supported auth mode
SQL
0 vote355 views1 answer
Oracle sql copy table without data
SQL
0 vote349 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote394 views1 answer
Mariadb.service failed with result 'exit-code'
SQL
0 vote322 views1 answer
Mysqlimport
SQL