same plan, different execution time, i/o
Hi,
I am learning analyzing sqlt report, and here same plan hash value/plan used but query processed different number of rows..so time also very different.
Any way to check if data was different or not or anything else to check for diefferent timings?
List ordered by phv, source and instance.
# | Plan Hash Value | Src | Source | Plan Info | Plan Stability | Is Bind Sensitive | Inst ID | Stats | Total Elapsed Time in secs | Total CPU Time in secs | Total User I/O Wait Time in secs | Total Other Wait Time in secs1 | Total Buffer Gets | Total Disk Reads | Total Direct Writes |
---|