THE SQL Server Blog Spot on the Web

Welcome to - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » Performance » Query Processin... » SQL Server 2005   (RSS)
Sorry, but there are no more tags available to filter with.
  • Performance Impact: Bookmark Lookup is Expensive - Even in Memory

    It’s well known that bookmark lookup (aka key lookup in case of a clustered index) is not cheap, especially when it comes to retrieving a lot of data. So I’m not going to rehash the pros and cons of bookmark lookup or why bookmark lookup is expensive. But I’ve noticed that when it comes to discussing bookmark lookup, all the literature seems ...
    Posted to Linchi Shea (Weblog) by Linchi Shea on July 6, 2008
Privacy Statement