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 |