Which is better: Bookmark/Key Lookup or Index Seek

Viewed 31177

I know that an index seek is better than an index scan, but which is preferable in SQL Server explain plans: Index seek or Key Lookup (Bookmark in SQL Server 2000)?

Please tell me they didn't change the name again for SQL Server 2008...

3 Answers
Related