Re: Gathering statistics on function-based index

2003-06-03 Thread elain he
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]>

Re: Gathering statistics on function-based index

2003-06-03 Thread Wolfgang Breitling
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

RE: Gathering statistics on function-based index

2003-06-03 Thread Gogala, Mladen
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