Show TOC

Tables/Views/SynonymsLocate this document in the navigation structure

Use

You can use the Database Objects user menu in the DBA Cockpit to obtain information about a specified database table, view table, or their synonyms.

Procedure

  1. Open the DBA Cockpit (transaction DBACOCKPIT) and choose Start of the navigation path Diagnosis Next navigation step Database Objects Next navigation step Tables/Views/Synonyms End of the navigation path.

  2. 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 a ", the subsequent letters are not changed into all caps, but instead are used for the query as you have entered them.

  3. Decide which database objects you want to display:

    Tables, views, and synonyms

    Only tables

    Only tables with a data store clustered on the database side

    Only views

    Only synonyms

  4. Choose Start of the navigation path Database Object Information Next navigation step  Display End of the navigation path.

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

  6. Choose Display Tables/View Info.

Caution

For SAP NetWeaver 7.1, you can access this display through the Tables/Views/Synonyms user menu.

Result

You can choose from the following displays:

  • Attributes: 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 database 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 Information published on SAP site.

  • 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 Instruction (only for view tables):  CREATE VIEW instruction that was used for creating the view table.

  • Table Keys (only for view tables): Primary tables on which the view table is based.

  • Distribution Key (only for the bridge function): Information about distributing data source keys.

  • Partitioning (only for the bridge function): Information about partitioning conditions in data sources.

  • Teradata Optimizer (only for the bridge function): Information about table statistics with specification of the execution time and spot test size of the update run.

  • 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 Browser: Display the object's data using the Data Browser (transaction SE16)

  • 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 Information published on SAP site.

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 Start of the navigation path Table/View Next navigation step Optimizer-Relevant Information End of the navigation path for a summary of those displays mentioned above that are relevant to the SQL optimizer.

More Information