Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Index vs. table scans in statspack reports
In stats$sysstat there is:
"db file sequential reads" (index access)
"db file scattered reads" (full-table scan access)
Have you tried improving your statistics with a deep sample using dbms_stats?
Also locating columns for histograms might help.
Do you have "missing" indexes? Received on Fri Nov 28 2003 - 06:48:27 CST