Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Query Plan & Partitions Expand / Collapse
Author
Message
Posted Wednesday, February 16, 2011 7:04 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, March 12, 2014 9:59 PM
Points: 7, Visits: 41
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?
Post #1064946
Posted Wednesday, February 16, 2011 8:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, July 16, 2014 11:15 PM
Points: 188, Visits: 346
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.
Post #1065048
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse