Re: Creating extended stats on a ASCENDING/DESCENDING index

> It looks like the extension is created automagically, along with the
> index:

This applies to any function based index:

SQL> select table_name,extension_name,droppable from user_stat_extensions;

no rows selected

Elapsed: 00:00:00.00
SQL> create index test1 on emp(lower(ename));

Index created.

Elapsed: 00:00:00.27
SQL> select table_name,extension_name,droppable from user_stat_extensions;

TABLE_NAME EXTENSION_NAME DRO

------------------------------ ------------------------------ ---
EMP			       SYS_NC00009$		      NO

Elapsed: 00:00:00.01
SQL> drop index test1;

Index dropped.
Elapsed: 00:00:01.12
SQL> select table_name,extension_name,droppable from user_stat_extensions;

no rows selected

Elapsed: 00:00:00.00

So, with a function based index the user will get a free stats extension. Cute, but would be even cuter if that was documented.

-- 
http://mgogala.byethost5.com