Statstics on Dictionary tables....

[Jr]

Is there any specific link or info about
why Statistics on Dictionary Tables is a disaster.


Jr.

[Shestakov]

What do u mean more exactly, when wrote:
"... Dictionary Tables is a disaster"
Can u a little bit explain ur question?

[pando]

because dictionary uses RULE optimizer

[Jr]

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?


Thanx
Jr.

[Edited by Jr on 03-29-2002 at 03:59 PM]

[Shestakov]

Jr i'm just didn't understand ur query clear, a liitle bit with error.
"Statistics ON Dictionary Tables is a disaster" and
"Statistics IN Dictionary Tables is a disaster"
have different means.

[Jr]

I mean,
why analyze on sys schema is not advised .

Thanx.
Jr.

[pando]

because it uses RULE optimizer