Creating extended stats on a ASCENDING/DESCENDING index

From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Tue, 5 Jun 2012 17:21:05 +0000 (UTC)
Message-ID: <jqlf61$e01$1_at_solani.org>

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

Received on Tue Jun 05 2012 - 12:21:05 CDT