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

[Back to original message]