I am going to implement a nightly script which will remove all records in a Feature Class in our spatial DB, and append new records.
Apart from compressing the Database, is there anything else I should manage? Analyze ? Should I remove any locks that could be connected?
This process will run every night.
Will compressing the entire DB have an effect with any child/parent DBs ?
Also, are you able to compress a single Feature Class rather than an entire DB ?
we run 10.2