Bookmark Lookup is a pre-2005 term. You can find info on it here http://blogs.msdn.com/b/craigfr/arc...52639.aspx
. In 2005 and later it shows up as a nested loop join and uses a Clusered Index Seek with a RID lookup. But I would have to ask why you want to find all these? You can't get rid of all bookmark lookups and don't fall into the myth that they are all evil. They are simply necessary in many cases. You would be better spending your time looking for plans that are overall ineffecient regardless of the reason. Choose the top x ones that get called the most in combination with the worts resource usage and tune them.