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 » Undocumented » Iterators » Query Plans   (RSS)
  • A Tale of Two Index Hints

    If you look up Table Hints in Books Online, you’ll find the following statement: If a clustered index exists, INDEX(0) forces a clustered index scan and INDEX(1) forces a clustered index scan or seek. If no clustered index exists, INDEX(0) forces a table scan and INDEX(1) is interpreted as an error. The interesting thing there is ...
    Posted to Page Free Space (Weblog) by Paul White on September 22, 2010
  • Iterators, Query Plans, and Why They Run Backwards

    Iterators SQL Server uses an extensible architecture for query optimisation and execution, using ‘iterators’ as basic building-blocks.  Iterators are probably most familiar in their graphical showplan representation, where each icon represents a single iterator.  They also show up in XML query plan output as RelOp nodes. Each ...
    Posted to Page Free Space (Weblog) by Paul White on August 4, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement