Re: DBA Tip of the Month: Index Browning

From: Winnie Liu <oracle_dba_at_zdnetmail.com>
Date: Mon, 21 Sep 1998 21:27:08 -0700
Message-ID: <6u78lv$1h6@dfw-ixnews5.ix.netcom.com>

I believe you have to issue something like :

analyze index <indexname> validate structure.. to generate information for index_state. not just any analyze with compute statistics.

Winnie

Ken Walters wrote in message <36065c5e.1127503874_at_nntp.pbs.org>...
>On Fri, 18 Sep 1998 13:30:07 -0400, Devinder Pal Singh
><Devinder_Pal.Singh_at_pharma.novartis.com> wrote:
>
>>When you analyse your index look for this information in index_stats.
>
>My sys.index_stats table is empty, but I just did a full analyze
>compute statistics. Do I need to do something special to have it store
>the index information in this table?
>--
>Ken Walters
>kwalters_at_pbs.org
>DBA
>Public Braodcasting Service
>kwalters_at_pbs.org
Received on Mon Sep 21 1998 - 23:27:08 CDT