How can Bookmark look up be ignored?

Question

Bookmark look up is taking long time when executing a SQL 2000 query. How can this issue be solved using Query hint or Index?

Answer 1

I highly recommend getting a proper understanding of this situation and how to address it. So instead of giving a cut down overview, it would be more beneficial for you to have a read through this MSDN article.

That explains exactly what it means, shows some samples and how to address it. Well worth a read.