Re: Creating extended stats on a ASCENDING/DESCENDING index

From: joel garry <>
Date: Tue, 5 Jun 2012 13:49:48 -0700 (PDT)
Message-ID: <>

On Jun 5, 1:36 pm, dombrooks <> wrote:
> 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:

(seeing this after I posted) Ah, that gets it. The docs say you can't have a virtual column, and Richard says there is a hidden virtual column as a consequence of the descending FBI.


-- is bogus.
Received on Tue Jun 05 2012 - 15:49:48 CDT

Original text of this message