Reorganizing Table Analyses

You have several options for monitoring and regulating the space table analyses use on the database:

Reorganization of table analyses

Reorganization Options

Description

Retain the latest table analysis for each table and analysis variant

For each table and analysis variant only the latest analysis is retained in the system with the status Completed, and all other table analyses are deleted.

Exception

Analyses with the status Scheduled as background job or In process are retained.

Delete table analyses that were performed before a certain date

All of the analyses performed before a specified date are deleted. The reference date is the start date of the analysis.

Refresh table analyses that were performed before a certain date

All of the analyses performed before a specified date are deleted. A new analysis for the relevant table is performed using the same analysis variant.

 

You are advised to reorganize table analyses regularly (choose Utilities ® Reorganize Analyses), as the results of all table analyses are saved in database tables and may use up a considerable amount of space.

Analysis variants have been provided to enable you to determine how much space the analyses are using. The usage of space is specified as the number of table rows in table TAAN_DATA. You can find most of the information regarding analyses you have performed stored in this table.

Analysis variants for determining space usage

Analysis Variant

Description

TAANA_ANALYSE_BY_OBJECT

Space usage for each table and analysis variant

TAANA_ANALYSE_BY_DATE

Space usage for each month and year in which you have performed analyses