Total logical I/O and total physical I/O

The <totalLio> and <totalPio> tags indicate the total logical I/O and total physical I/O per plan. There are two sets of <totalLio> and <totalPio> tags that indicate the actual and estimated values of the logical and physical I/O.

For more information on logical I/O and physical I/O, see “Displaying Query Optimization Strategies and Estimates” in the Performance and Tuning Series: Query Processing and Abstract Plans.

Example

select show_cached_plan_in_xml(1123220018, 0)
go

    <text>
           <![CDATA[
                SQL Text: select * from titles]]>
    </text>
<Plan>
<optTree>
. . . 

         
            <est>
                <totalLio>3</totalLio>
                <totalPio>3</totalPio>
            </est>
            <act>
                <totalLio>3</totalLio>
                <totalPio>1</totalPio>
            </act>
. . .