Posted by serge on 12/10/06 05:59

If you display the execution plan and run the following:

SET STATISTICS IO ON
go

SELECT ProductID, SupplierID
FROM Products
WHERE SupplierID = 1


I don't understand how come there is no
Bookmark Lookup operation happening to get the
ProductID?

I only see an Index Seek happening on SupplierID.
There is no composite index SupplierID + ProductID
so what am I not understanding here?

Thank you

• Next in forum: Re: Northwind - execution plan bug? Why Index Seek and no Bookmark Lookup?
• Prev in forum: Introducing pitchbuster.com - Bust those sales pitches against MSSQL
• Thread view: Northwind - execution plan bug? Why Index Seek and no Bookmark Lookup?

[Reply to this message]