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?
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.