Re: Creating extended stats on a ASCENDING/DESCENDING index

From: dombrooks <>
Date: Tue, 5 Jun 2012 13:36:31 -0700 (PDT)
Message-ID: <>

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: Received on Tue Jun 05 2012 - 15:36:31 CDT

Original text of this message