improve my number disk's access read 1M230 to retrieve 465 rows
hello,
I would like reduce the disk's read i have executed tkprof.
1 - i see tkprof's report and I see disk 1018569 and 1234680 for retrieve 465 rows. and CPU 26.36
how may I improve it ? i suppose that my statistics are correct but I am not sur. How may i control ?
afterwards maybe I can improve by histogramme, how may I to do ?
what do you think about it ? or have an other solution to improve it ?
2 - I see this next and i would understand the signification :
db file scattered read 99261 0.00 3.90
db file sequential read 19442 0.01 0.13
best regards
JP
call count cpu elapsed disk query current rows
I would like reduce the disk's read i have executed tkprof.
1 - i see tkprof's report and I see disk 1018569 and 1234680 for retrieve 465 rows. and CPU 26.36
how may I improve it ? i suppose that my statistics are correct but I am not sur. How may i control ?
afterwards maybe I can improve by histogramme, how may I to do ?
what do you think about it ? or have an other solution to improve it ?
2 - I see this next and i would understand the signification :
db file scattered read 99261 0.00 3.90
db file sequential read 19442 0.01 0.13
best regards
JP
call count cpu elapsed disk query current rows
0