TKPROF STATISTICS-To Mr.Daljit Singh [message #65106] |
Fri, 30 April 2004 03:11 |
Monu
Messages: 5 Registered: April 2004
|
Junior Member |
|
|
Mr Daljit
Thanks for replying!
I have collected the following statistics using TKPROF,So can i assume that the second data collected is better since i have added optimizer hints in my procedures
Before adding optimizer hints
call count cpu elapsed disk query current rows
--------------------------------------------------------------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.15 0.23 6 8 2 0
Fetch 0 0.00 0.00 0 0 0 0
------------- -------- ---------- ---------- -----------------
total 2 0.15 0.23 6 8 2 0
After adding optimizer hints
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ------
Parse 1 0.00 0.00 0 0 0 0
Execute 1 0.09 0.07 0 0 2 0
Fetch 0 0.00 0.00 0 0 0 0
------- ------ -------- ---------- ---------- ---------- ------
total 2 0.09 0.07 0 0 2 0
Which data are better?
Thankx
Gaurav
|
|
|