Post reply

Help for nested loop joins

  • September 1, 2011 at 1:10 am

    #256463

    I have a query:

    select *

    from Sales S inner join Customers C

    on S.Cust_Id = C.Cust_Id

    There is a non clustered index on Sales. Sales and Customers table just carry some sample test data.

    Execution plan is showing 2 nested loops and a RID loop up.

    Why is it using 2 nested loop and what is RID look up used in this case?

    Please help..

    Thanks,

    Kirti

  • September 1, 2011 at 1:19 am

    #1375811

    this may help explain:

    http://technet.microsoft.com/en-us/library/ms190696.aspx

    ________________________________________________________________
    you can lead a user to data....but you cannot make them think
    and remember....every day is a school day

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply