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?
12-07-2001, 08:10 AM
yes very bad, you must not do it
12-07-2001, 08:44 AM
Even though the indexes may be badly fragmented
12-07-2001, 08:46 AM
oh yes, even itīs badly fragmentated I wouldnt do it without caling support first
12-07-2001, 08:48 AM
If you use CBO, do you analyze after the IMP?
12-07-2001, 11:39 AM
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.
12-08-2001, 08:03 AM
Do you transfer logical models from ERWIN to Designer?
About SYS' analyze: One sshould never analyze SYS' objects.