Re: Creating extended stats on a ASCENDING/DESCENDING index
From: joel garry <joel-garry_at_home.com>
Date: Tue, 5 Jun 2012 13:49:48 -0700 (PDT)
Message-ID: <f2b35d22-af3c-41b2-bf9a-2b789d2950cd_at_tx6g2000pbc.googlegroups.com>
On Jun 5, 1:36 pm, dombrooks <dombro..._at_hotmail.com> 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:http://richardfoote.wordpress.com/category/descending-indexes/
Date: Tue, 5 Jun 2012 13:49:48 -0700 (PDT)
Message-ID: <f2b35d22-af3c-41b2-bf9a-2b789d2950cd_at_tx6g2000pbc.googlegroups.com>
On Jun 5, 1:36 pm, dombrooks <dombro..._at_hotmail.com> 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:http://richardfoote.wordpress.com/category/descending-indexes/
(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.
jg
-- _at_home.com is bogus. http://www.utsandiego.com/news/2012/jun/04/mortgage-fraud/Received on Tue Jun 05 2012 - 15:49:48 CDT