\nLet’s say you are querying a partitioned table and you would like to see which partitions were accessed by looking at the graphical execution plan:\n<\/p>\n
\n \n“Actual Partition Count” shows a value of 1 and “Actual Partitions Accessed” shows a value of 50. The “Actual Partitions Accessed” property name could cause confusion though, since what you’re actually looking at is the partition numbers accessed (not the count<\/em> of partitions accessed). \n<\/p>\n \nI prefer the XML naming convention instead:\n<\/p>\n \n\t \nThe name mapping is as follows from Graphical-to-XML Plan formats:\n<\/p>\n \n\t“Actual Partition Count” = PartitionsAccessed element & PartitionCount attribute\n\t<\/p>\n \n\t“Actual Partitions Accessed” = PartitionRange\n\t<\/p>\n<\/blockquote>\n \nIf I modify the query to access two partitions, I see the following (graphical and XML plan output):\n<\/p>\n
<\/a>\n<\/p>\n\n
\n\t <PartitionsAccessed PartitionCount="1">
\n\t <PartitionRange Start="50" End="50" \/>
\n\t <\/PartitionsAccessed>\n\t<\/p>\n<\/blockquote>\n\n