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 » Query Plans » Partitioning   (RSS)
  • Why Doesn’t Partition Elimination Work?

    Given a partitioned table and a simple SELECT query that compares the partitioning column to a single literal value, why does SQL Server read all the partitions when it seems obvious that only one partition needs to be examined? Sample Data The following script creates a table, partitioned on the char(3) column ‘Div’, and populates it with ...
    Posted to Paul White: Page Free Space (Weblog) by Paul White on September 11, 2012
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement