Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Index vs. table scans in statspack reports

Re: Index vs. table scans in statspack reports

From: Geomancer <pharfromhome_at_hotmail.com>
Date: 28 Nov 2003 04:48:27 -0800
Message-ID: <cf90fb89.0311280448.4f19c3e3@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US