Function documentationDB Filling/Tables and Indexes Locate this document in the navigation structure

 

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   Database: Monitoring and Configuration   Datatabase Performance: Tables and Indexes   (Transaction DB02).

Prerequisites

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, select   Diagnosis   Missing Tables and Indexes  .

    More information: Scheduling a Database Structure Check