Joins Of SQL Server

So this comes in to your mind that the joins in sql are Inner join, left join , right join , cross join well the thing is that sql server does not know that, for sql server its just syntax which is decoded and sql server works on it in the following three plans.


Nested Loop


Plan to be selected depends on many things, For example size of tables to be joined, order , whether they are indexed or not, these tiny details tell the sql server which approach to select. Please refer to the detailed posts


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s