Home Forums SQL Server 2008 SQL Server 2008 - General Query Plan & Partitions RE: Query Plan & Partitions
PKDC
SSChasing Mays
Points: 618
More actions
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.