Re: help:what is the difference btwn two analyze index?

From: Connor McDonald <connor_mcdonald_at_yahoo.com>
Date: Thu, 21 Jun 2001 21:05:35 +0100
Message-ID: <9gtk12$810$1@news.chatlink.com>

issue a select count(*) against the table and post back which one it was..

Cheers

--
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."
<u518615722_at_spawnkill.ip-mobilphone.net> wrote in message
news:l.993045162.1770446777@[198.138.198.252]...


> Hi, folks

>

> Could somebody tell me what is the difference between

>

> analyze index name compute statistics

> then select against user_indexes

>     BLEVEL INDEX_NAME                     DISTINCT_KEYS

> ---------- ------------------------------ -------------

>          2 HISTORICAL_PK                  18473672

>

>

> analyze index name validate structure

> then select against index_stats

>

>     HEIGHT     BLOCKS NAME                           DISTINCT_KEYS

> ---------- ---------- ------------------------------ -------------

>          3      45120 HISTORICAL_PK                  11692267

>

>

> Which one gives the more accurate results?

>

> Thanks

>

>

>

>

> --

> Sent by dbadba62  from hotmail piece from com

> This is a spam protected message. Please answer with reference header.

> Posted via http://www.usenet-replayer.com/cgi/content/new

Received on Thu Jun 21 2001 - 15:05:35 CDT