In Oracle, the indexes do not tend to shrink automatically even if data is deleted. The standard advice is to rebuild the index on a regular basis. Below is a summary of index compression guidelines in relation to Geneos:
- If the index compression does not alter the Geneos table structure, it is okay to use it.
- If it does alter the said table structure and does affect the results of SQL queries like retrieving values to populate the the Active Console (e.g. generating history charts), it is NOT okay to implement it.
- The Gateway specifically does not do anything to support/not support index compression.
- The node_ref_table and var_ref_table should not be altered.
For more information, refer to the following link: Oracle table reorganization: Online or Offline.
Out of scope
Index management is unfortunately out of ITRS' scope. Either refer to the guidelines above or raise this to a database administrator.