Show TOC

DB Filling/Tables and IndexesLocate this document in the navigation structure

Use

In this display of the database administration in CCMS, you see information about the database fill level and the database objects (tables and indexes). You can determine which indexes are missing, and check the consistency of database objects and ABAP Dictionary objects.

Integration

In the user menu, select Start of the navigation path Database: Monitoring and Configuration Next navigation step Datatabase Performance: Tables and Indexes End of the navigation path (Transaction DB02).

Prerequisites
Features

In addition to entries about the database, you can see the following information:

  • Data Area Usage

    You can have the system display Fill level statistics next to the size specifications.

    More information: Database Fill Level

  • Database Tables/Indexes of the Schema <schema_name>

    You can have the system display Table/View Information and Table Size Statistics, in addition to the number of tables and indexes.

    More information: Tables/Views/Synonyms, Table Sizes

    More information: Index Analysis, Indexes

  • Consistency Check Results

    Gives you a display of the number of missing or unknown objects in the database or the ABAP/4 dictionary. For further analysis, choose Missing Tables/Indexes. The results of the consistency check are displayed.

    You can also obtain the results of the consistency check with the DBA Cockpit (transaction DBACOCKPIT). In the DBA Cockpit, choose Start of the navigation path Diagnosis Next navigation step Missing Tables and Indexes End of the navigation path.

    More information: Missing Tables and Indexes

    More information: Scheduling a Database Structure Check

More Information