Re: analyze index > no records in INDEX

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 11 Nov 1998 23:07:55 +0100
Message-ID: <364A0ABB.CDFC5A69@sybrandb.demon.nl>

Analyze index will return results in user_indexes. Analyze index <index name> validate structure will return results in index_stats. NB: this table will hold results for 1 index only!

Hth,

Sybrand Bakker, Oracle DBA

IOPS wrote:

> Newbie DBA running Oracle 7.3 on solaris. Ran analyze index but no
> records were posted to INDEX_STATS. Any idea on what to check?
>
> Tks

Received on Wed Nov 11 1998 - 16:07:55 CST

Re: analyze index > no records in INDEX_STATS