AL_STATS : NO
DOMIDX_STATUS :
DOMIDX_OPSTATUS :
FUNCIDX_STATUS: ENABLED
-----
From: Wolfgang Breitling <[EMAIL PROTECTED]>
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Have you tried methods 3 or preferrably method 4:
method 3: analyze index compute statistics
method 4: exec dbms_stats.gather_index_stats(...)
What do you mean by "the output below is similar for both methods"? What
are the differences? Can you use Tom Kyte's print_table procedure to list
the
Does this look familiar?
Bug No. 2782919
Filed 03-FEB-2003 Updated 20-MAY-2003
Product Oracle Server - Enterprise Edition V7 Product Version 9.2.0.2.0
Platform Sun SPARC Solaris (64-BIT) Platform Version 2.8
Database Version 9.2.0.2.0 Affects Platforms Generic
Priority Severe Loss of Servic