Partitions Accessed and Partition Range in the Query Execution Plan
Let’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: “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 … Continue reading Partitions Accessed and Partition Range in the Query Execution Plan