THE SQL Server Blog Spot on the Web

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

Browse by Tags

All Tags » Internals » DMVs » Seeks   (RSS)
  • Seeking Without Indexes

    A seek can contain one or more seek predicates – each of which can either identify at most one row in a unique index (a singleton lookup) or a range of values (a range scan).  When looking at a query plan, we will often need to look at the details of the seek operator in the Properties window to see how many operations it is performing, and ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on February 17, 2011
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement