Re: Creating extended stats on a ASCENDING/DESCENDING index
Date: Tue, 5 Jun 2012 13:36:31 -0700 (PDT)
A descending index is a function-based index so... in terms of your original qustion you might want to try something like:
select dbms_stats.create_extended_stats(user,'EMP','(SYS_OP_DESCEND(SAL))') from dual;
I'd probably be more interested in why the index isn't being used.
I'm sure you're familiar with Richard Foote's writings: http://richardfoote.wordpress.com/category/descending-indexes/ Received on Tue Jun 05 2012 - 15:36:31 CDT