Re: Creating extended stats on a ASCENDING/DESCENDING index

From: dombrooks <dombrooks_at_hotmail.com>
Date: Tue, 5 Jun 2012 13:36:31 -0700 (PDT)
Message-ID: <6abef7ca-1efc-4e9f-bf25-3653c5aa610c_at_googlegroups.com>



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

Original text of this message