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 » Undocumented » Internals » Iterators   (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 Paul White: 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 Paul White: Page Free Space (Weblog) by Paul White on August 4, 2010
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement