Creating extended stats on a ASCENDING/DESCENDING index
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?
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?
0