40.2. Viewing Indexes #

  1. In the navigation panel, go to Databases.

  2. (Optional) To display system databases, turn on Show system databases.

  3. Click the name of the database.

  4. Click the name of the schema.

  5. Click the name of the table.

  6. Select Indexes.

The table of indexes with the following columns will be displayed:

  • Indexes: The unique name of the index.

  • Total size.

  • CFS: Specifies whether the CFS compression is used for the index.

  • Status.

    Possible values:

    • valid: The standard state in which the index can be used in queries.

    • invalid: The index cannot be used in queries. This status indicates that the index is being created or was damaged.

  • Actions.

    For more information about available actions, refer to the corresponding instructions.

Important

If an index is created outside PPEM, the information about it can be displayed in the web application with a delay. The delay duration depends on the agent configuration. By default, it is one minute.