Back to Geneos FAQ

Oracle index does not shrink when deleting data from a table

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.

The following guidelines is a summary of index compression 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, such as 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 Oracle table reorganization: Online or Offline.

Note

Index management is unfortunately out of ITRS’ scope. Either refer to the guidelines above or raise this to a database administrator.