/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 vote192 views1 answer
Utf8_encode mysql
SQL
1 vote202 views2 answers
Full join
SQL
4 votes165 views1 answer
Select nls_date_format
SQL
15 votes164 views2 answers
Open postgress in terminal mac
SQL
0 vote235 views1 answer
Oracle convert int to date
SQL
13 votes184 views6 answers
Mysql remove duplicates
SQL
5 votes168 views2 answers
Ranking functions in sql
SQL
2 votes163 views1 answer
Sql get the name of user pc
SQL
4 votes181 views1 answer
Create db table
SQL
0 vote166 views1 answer
Soql last week
SQL