Re: Index vs. table scans in statspack reports

From: Rick Denoire <100.17706_at_germanynet.de>
Date: Sat, 29 Nov 2003 01:33:23 +0100
Message-ID: <1tpfsvkgetd66e4368p0q9aggldebobthq@4ax.com>

pharfromhome_at_hotmail.com (Geomancer) wrote:

>
>Have you tried improving your statistics with a deep sample using dbms_stats?

I hope you are kidding. Gathering statistics is being done regularly, of course. Otherwise queries would run for months probably.

>Also locating columns for histograms might help.

Exactly. That is what I am considering as a next step. Of course, one has to identify candidate columns that would profit from histograms.

>Do you have "missing" indexes?

I don't care about missing indexes, I don't write applications. I care for *unused* indexes (which I remove), or indexes that need rebuilding.

Bye
Rick Denoire Received on Fri Nov 28 2003 - 18:33:23 CST