CODEWITHSUNDEEP
sqlsql-server-2008
Ashutosh Arya
Ashutosh Arya

Reputation: 1168

Outer apply and left join

I am using outer apply in sql server. can someone please explain if there is any performance difference between Outer Apply and Left Join ?

Upvotes: 3

Views: 8082

Answers (1)

MikkaRin
MikkaRin

Reputation: 3084

Your question is not really correct.

APPLY uses to join table with table-valued functions

JOIN we use to join two tables.

You may find more information in MSDN articles:

APPLY http://technet.microsoft.com/en-us/library/ms175156(v=sql.105).aspx.

JOIN http://technet.microsoft.com/en-us/library/ms191517(v=sql.105).aspx

Upvotes: 2

Related Questions