Post reply

Query Plan & Partitions

  • February 16, 2011 at 7:04 am

    #232263

    The purpose for partitioning a table is to reduce the number of rows that must be scanned in order to satisfy a given query. If a table is partitioned based on the query predicate, can the user verify that the query planner is selectively scanning the relevant data by viewing the the query plan?

  • February 16, 2011 at 8:38 am

    #1287727

    You can check it by looking at the execution plan property of the index that is used in your query. If expand the Actual Number of Rows, it will display the Actual Partition Count and Actual Partitions Accessed info.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply