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

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Thu, 21 Jun 2001 21:43:45 +0100
Message-ID: <993156119.20183.2.nnrp-13.9e984b29@news.demon.co.uk>

Were these two statement run at about the same time with no large load/delete in
between.

One possible reason for the discrepancy in rows could be the result of having a compressed index.

The difference in height is to be expected, INDEX_STATS counts the root block as one more level, USER_INDEXES ignores it.

--
Jonathan Lewis

Host to The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Author of:
Practical Oracle 8i: Building Efficient Databases
See http://www.jlcomp.demon.co.uk/book_rev.html

Seminars on getting the best out of Oracle
See http://www.jlcomp.demon.co.uk/seminar.html






u518615722_at_spawnkill.ip-mobilphone.net wrote in message ...


>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:43:45 CDT