Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> help:what is the difference btwn two analyze index?
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/newReceived on Wed Jun 20 2001 - 08:52:41 CDT