I am facing a typical problem in my SP, actually the SP is using may temp tables.
For better logic i have removed a temp table (#AggreTemp), when i see the Statistics IO of my SP that temp table(#AggreTemp) is still showing in IO. But the SP Is working fine. i have double checked that the "#AggreTemp" is used in the SP Or not, it is not in the SP.
i have tried by clearing the Proc Cache FreeProceCache/DropCleanbuffers even it is showing in the Statistics IO.
Please help me on this.