Statstics on Dictionary tables....
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Statstics on Dictionary tables....

  1. #1
    Join Date
    Jan 2002
    Posts
    148
    Is there any specific link or info about
    why Statistics on Dictionary Tables is a disaster.


    Jr.

  2. #2
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    What do u mean more exactly, when wrote:
    "... Dictionary Tables is a disaster"
    Can u a little bit explain ur question?

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    because dictionary uses RULE optimizer

  4. #4
    Join Date
    Jan 2002
    Posts
    148
    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]

  5. #5
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    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.


  6. #6
    Join Date
    Jan 2002
    Posts
    148
    I mean,
    why analyze on sys schema is not advised .

    Thanx.
    Jr.

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    because it uses RULE optimizer

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width