Dynamic partition elimination

show_cached_plan_in_xml shows dynamic partition elimination information within the “partitionInfo” section using the <dynamicPartitionElimination> tag, which indicates it is performing runtime partition elimination. show_cached_plan_in_xml indicates the compile time partition elimination under the <eliminatedPartition> tag.

For more information on partition elimination, see the chapter on parallel query processing in the Performance and Tuning Series: Query Processing and Abstract Plans.

Example 2

select show_cached_plan_in_xml(435436901,0)
go

<query>
   <statementId>435436901</statementId>
   <text>
   <![CDATA[

. . .

                    <partitionInfo>
                        <partitionCount>3</partitionCount>
                        <eliminatedPartition>1</eliminatedPartition>
                        <eliminatedPartition>3</eliminatedPartition>
                        <dynamicPartitionElimination>No</dynamicPartition
                         Elimination>
                   </partitionInfo> 

. . .