Show TOC

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

Prerequisites

Prerequisites

Features

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

  • Data Area Usage

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

    See also: 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.

    See also: Tables/Views/Synonyms, Table Sizes

    See also: 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  .

    See also: Scheduling a Database Structure Check