DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Analyzing system tables ...?

  1. 11-18-2000, 02:20 AM #1
    aji.thm
    aji.thm is offline Junior Member
    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
    Reply With Quote Reply With Quote
  2. 11-18-2000, 02:35 AM #2
    wjramsey
    wjramsey is offline Member
    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
    Reply With Quote Reply With Quote
  3. 11-18-2000, 02:46 AM #3
    aji.thm
    aji.thm is offline Junior Member
    Join Date
    Nov 2000
    Posts
    20
    Thanks a lot.....


    ..thomas
    Thomas
    Reply With Quote Reply With Quote
  4. 11-18-2000, 02:47 AM #4
    wjramsey
    wjramsey is offline Member
    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
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width