The Problem Analysis user menu shows you, among other things, information about a specified database table, view tables, or their synonyms.
You can choose from the following displays:
Properties: Type, access rights, date created and changed, date of the last run to determine table consistency (for tables only), default sample to update optimizer statistics (tables only), and specifications about cost saving by clustering of tables (only for tables)
You can check the database structures (for a single table of the SAP MaxDB or SAP liveCache system).
You can change the default value for the sample size to update the SQL optimizer statistics of a table (in rows or percent). If this value is 0, a warning message appears stating that the update of optimizer statistics using the sample size is deactivated.
Definition: Definition of the object in the database instance (this is not the object definition from the ABAP Dictionary but the object definition according to the system tables of the database system).
If the object has a virtual key, it is displayed here. Further information about the data store clustered on the database side can be found in SAP Note 1040431 .
Indexes: Display of all indexes (inactive, unused, bad indexes) that were defined for this object. Among other things, you can activate or deactivate indexes or restore or reset the usage counter.
CREATE statement (only for view tables): CREATE VIEW statement that was used to generate the view table
Table key (only for view tables): Primary key for tables that form the basis for the View table.
Optimizer statistics: The latest values calculated for the SQL optimizer statistics, specifying the execution time and the sample size of the update run.
You can have the system display whether the SQL optimizer statistics need to be updated (Requested Updates). You can update the statistics for this table (Update (Standard)) or selected columns from this table (Update (Selected Columns)) with any sample size (in rows or percent).
Exact Sizes: Exact size of tables and indexes
Data Store (only for data store clustered on the database side): Information about clustering of the object
Further information about the data store clustered on the database side can be found in SAP Note 1040431 .
If you have opted to have a synonym displayed, you will receive a display where the synonym refers to the object (table or view table). You can jump to the display of the corresponding object.
Choose
for a summary of those displays mentioned above that are relevant to the SQL optimizer.DBA Planning Calendar,
Scheduling Updates of the SQL Optimizer Statistics
DBA Cockpit:SAP MaxDB, Tables/Views/Synonyms
Database Studio, Updating SQL Optimizer Statistics
Database Administration,