Reorganizing Table Analysis

Procedure

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

Reorganizing Table Analyses

Reorganization Options	Description
Retain most recent table analysis for each table and analysis variant	The system only retains the latest analysis with the status Completed for each table and analysis variant and deletes all other table analyses. Exception: Analyses with the status Scheduled as Background Job and 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.

We recommend reorganizing table analyses regularly (choose Start of the navigation path Utilities Next navigation step Reorganize Analyses... End of the navigation path ), since the results of all table analyses are saved in the database tables (TAAN*), and may use up a considerable amount of space .

Analysis variants have been provided to enable you to determine the space used by the analyses. The usage of space is specified as the number of table rows in table TAAN_DATA. You can find most of the information about analyses you have performed in this table.

Analysis variants for determining space usage

Analysis Variant	Meaning
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