Re: Creating extended stats on a ASCENDING/DESCENDING index
From: ddf <oratune_at_msn.com>
Date: Tue, 5 Jun 2012 13:56:07 -0700 (PDT)
Message-ID: <cca8965d-3a3a-45b6-a0b8-4b75f2359c7c_at_m10g2000vbn.googlegroups.com>
On Jun 5, 11:21 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I have an index which is created with "DESC" option and is not being used
> unless a hint is used. I am trying to create an extended statistics but I
> cannot get the syntax right:
>
> select dbms_stats.create_extended_stats(user,'EMP','("SAL" DESC)') from
> dual;
> select dbms_stats.create_extended_stats(user,'EMP','("SAL" DESC)') from
> dual
> *
> ERROR at line 1:
> ORA-20001: Error when processing extension - missing right parenthesis
>
> Has anybody done it?
>
> --http://mgogala.byethost5.com
Date: Tue, 5 Jun 2012 13:56:07 -0700 (PDT)
Message-ID: <cca8965d-3a3a-45b6-a0b8-4b75f2359c7c_at_m10g2000vbn.googlegroups.com>
On Jun 5, 11:21 am, Mladen Gogala <gogala.mla..._at_gmail.com> wrote:
> I have an index which is created with "DESC" option and is not being used
> unless a hint is used. I am trying to create an extended statistics but I
> cannot get the syntax right:
>
> select dbms_stats.create_extended_stats(user,'EMP','("SAL" DESC)') from
> dual;
> select dbms_stats.create_extended_stats(user,'EMP','("SAL" DESC)') from
> dual
> *
> ERROR at line 1:
> ORA-20001: Error when processing extension - missing right parenthesis
>
> Has anybody done it?
>
> --http://mgogala.byethost5.com
I haven't and I have also tried -- apparently extended statistics do not apply to descending column order, only to column groups or expressions involving two or more columns.
If anyone else can generate such extended statistics please show us how it's done.
David Fitzjarrell Received on Tue Jun 05 2012 - 15:56:07 CDT