Analyzing system tables ...?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Analyzing system tables ...?

  1. #1
    Join Date
    Nov 2000
    Posts
    20

    Unhappy

    Hai,

    Can i do a Analyze compute statistics on sys tables...?
    Will it increase my performance...?


    ...Thomas
    Thomas

  2. #2
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    NO NO NO NO NO!!!!

    BY NO MEANS ANALYZE YOUR SYSTEM TABLES!!!!!!

    For all the advantages that Oracle touts about using the cost based optimizer, they still require the use of the rule based optimizer on their own tables. If you analyze Oracle's tables they will tell you to delete all the statistics on their tables before they will support you.

    Joe

    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

  3. #3
    Join Date
    Nov 2000
    Posts
    20
    Thanks a lot.....


    ..thomas
    Thomas

  4. #4
    Join Date
    Jul 2000
    Location
    Oxford, OH
    Posts
    117
    *chuckle* Your welcome :)

    Just wanted to emphasize that you shouldn't do this *laugh*
    _________________________
    Joe Ramsey
    Senior Database Administrator
    dbaDirect, Inc.
    (877)687-3227

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