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.

Merge

Nested Loop

Hash

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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s