Optimize SQL querying of the audit tables for management reports and custom queries
Tune Table requires a representative set of data in your audit tables in order to effectively analyze and optimize querying. After one month of receiving data and having users log in and look up data in your system, run tune table on the following ATNA schemas:
If you receive DICOM data, also run tune table on the following schema:
If you make a change to your system’s data ingestion, for example adding IHE documents or DICOM data. You should run tune table again after one month of collecting the new data.
As tune table uses system resources, it should be run in off hours. Running tune table on a very large audit database with terabytes of data in a live system is not recommended. If a test system has a representative set of data, then one option is to run tune table on the test system and export the result to the live system.
For details on running the tune table utility, see “Tune Table” in Define High-Performance Schemas.