Re: question regarding statistics

The chain_cnt isn't used, but arguably it OUGHT to be used; in much the same way that the pct_direct_access has an effect on secondary indexes on IOTs. Keep an eye open for the day that dbms_stats suddenly starts to collect it.

Regards

Jonathan Lewis

http://www.jlcomp.demon.co.uk/faq/ind_faq.html The Co-operative Oracle Users' FAQ

http://www.jlcomp.demon.co.uk/seminar.html Public Appearances - schedule updated Jan 21st 2005

• Original Message ----- From: "Mladen Gogala" <mgogala_at_allegientsystems.com>

>Also, dbms_stats doesn't gather a number of stats like: EMPTY_BLOCKS,
>AVG_SPACE, CHAIN_CNT.
>

Those are not used by the optimizer. DBMS_STATS also doesn't give you the time of day, the age of Joan Rivers or birthplace of Bill O'Reilly. CHAIN_CNT is only used in BDSM optimizer, which is licensed separately in the kinky database option. Not many people use that.

--
http://www.freelists.org/webpage/oracle-l