The following list includes other typical tasks that you may want to consider:
You may want to recompile the database statistics. Will the purge perform better if the statistics are calculated beforehand? What effect will it have on the statistics used by the query optimizer?
You may want to rebuild or defragment the indexes. Will the purge perform better if the indexes are defragmented beforehand? What effect will deleting this amount of data have on the indexes?
You may want to remove indexes and key constraints while the purge runs and reinstate them afterwards. If deleting significant proportion of the data, would it be more efficient to 'drop' non-essential indexes and foreign key constraints during the purge process?
Shrinking or compacting the database.
You may want to reclaim DBMS space freed by the purge. Does this newly free space need to be released to the file system immediately?
|
Copyright © 2014 CA.
All rights reserved.
|
|