Originally posted by Shestakov What do u mean more exactly, when wrote:
"... Dictionary Tables is a disaster"
Can u a little bit explain ur question?
Couldnt say more about this but...
knew from few sources that its a wrong idea gathering stats for Dic Tables.
For instance http://www.oracledba.co.uk -> Tunig -> dbms_utility.analyze_table thread also refers to the same.
** I know we can always delete the statistics.
Originally posted by pando because dictionary uses RULE optimizer
If its RULE then doesnt it should overlook the stats whether they are available or not?