The optimizer considers a clustered index partition scan only when:
The query accesses at least 20 data pages of the table.
The table is partitioned and uses allpages locking.
The table’s data is not skewed in relation to the number of partitions. Table data is considered skewed when the size of the largest partition is two or more times the average partition size.
