Viewing index details

To see what columns are currently indexed, you can examine the contents of the catalog.indexes table either from the Netcool/OMNIbus Administrator interface, or by using the SELECT command.

About this task

To view index details in the catalog.indexes table, perform either of the following steps:

Procedure

  • From the Netcool/OMNIbus Administrator window:
    1. Select the System menu button.
    2. Click Databases. The Databases, Tables and Columns pane opens.
    3. Select catalog.indexes.
    4. Click the Data View tab on the Databases, Tables and Columns pane to view the table data.
  • From the SQL interactive interface, enter the following command: 
    select * from catalog.indexes;