Home Forums Article Discussions Article Discussions by Author Discuss Content Posted by Grant Fritchey SQL Server Execution Plans RE: SQL Server Execution Plans
Ninja's_RGR'us
SSC Guru
Points: 294069
More actions
November 14, 2011 at 4:21 am
#1407052
Sab must return less rows.
An index seek + bookmark lookup is a very costly operation. It takes very little data returned to make a table scan more efficient than a seek + lookup.