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

Thread: rebuilding sys indexes, analyzing sys tables

  1. #1
    Join Date
    Aug 2000
    Posts
    143

    Question

    I have a number of databases that are constantly getting refreshed from imports. Querys on data dictionary tables seem to take forever. I have a feeling it may be due to the ammount of delete and insert activity on the sys tables.

    Is it a bad idea to rebuild the sys indexes and analyze the sys tables from time to time?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    yes very bad, you must not do it

  3. #3
    Join Date
    Aug 2000
    Posts
    143
    Even though the indexes may be badly fragmented

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    oh yes, even it´s badly fragmentated I wouldnt do it without caling support first

  5. #5
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    If you use CBO, do you analyze after the IMP?


  6. #6
    Join Date
    Aug 2000
    Posts
    143
    I normally analyze after the imp, but not the sys tables. Im mostly running queries against the data dictionary to compare it with Erwin models and other development databases, so if anything it would be the sys tables and indexes that the queries are effecting.

    The only other way I can think of to get round this is to recreate the database periodically.

  7. #7
    Join Date
    Jun 2001
    Location
    Helsinki. Finland
    Posts
    3,938
    Do you transfer logical models from ERWIN to Designer?

    About SYS' analyze: One sshould never analyze SYS' objects.

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