Tables/Views/Synonyms

The Problem Analysis user menu (OLTP/ liveCache) shows you, among other things, information on a specified database table, view tables or their synonyms.

Procedure

...

       1.      Open the Database Assistant (transaction DB50) or the liveCache Assistant (transaction LC10).

       2.      Choose Problem Analysis ® Tables/Views/Synonyms.

       3.      Enter the schema of the database object and the name of the database object.

When you specify the schema or the name, you can also enter * as a wildcard for any character string (T0* for all table names that start with T0, for example).

If you begin the name of a database object with an "  the following letters are not changed into uppercase letters but rather are used for the query as you have entered them.

       4.      Decide which database objects you would like to be displayed:
Tables, Views and Synonyms
Only Tables
Only Views
Only Synonyms

       5.      Choose Database Object Information ®Display.

       6.      If necessary, mark the required object in the list provided for any additional analysis.

       7.      Choose Tables/View Info ® Display.

Result

You can choose from the following displays:

?     Properties: type, access rights, date created and changed as well as the date of the last run for determining optimizer statistics for this object
Table Consistency  (only for tables): You can check the database structures (for a single table in the OLTP or liveCache system).
Default sample (only for tables): you can display and change the default value for the sample size (in rows or as a percentage).

?     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).

?     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 which is used for creating the view table.

?     Table key (only for view tables): primary key for tables that forms the basis for the View table.

?     Optimizer statistics: last collected values for optimizer statistics
You can update the statistics for this table or select a column in this table with any sample size (in rows or as a percentage).

?     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 refer to the particular object in the display.

Choose Optimizer-relevant Information for a summary of those displays mentioned above that are relevant to the Optimizer.

See also:

Indexes

DBA Planning Calendar, Scheduling Updates in SQL Optimizer Statistics, Scheduling Database Structure Checks

Concepts of the Database System, SQL Optimizer Statistics, Checking Database Structures