Start of Content Area

Procedure documentation Analyzing Indexes of a Table with SAPDBA  Locate the document in its SAP Library structure

Use

You can use SAPDBA for Informix to see information about all the indexes of a table, including unique and duplicate indexes.

Prerequisites

Procedure

  1. Choose Reorganization → Analyze Index Reports → Indexes of Table in SAPDBA for Informix.
  2. In table name, enter data as required. If you do not know the name of the table you want, you can use a partial entry (for example, a0*) and SAPDBA lists the matching tables.
  3. Execute the report.

SAPDBA displays the report.

Note

Sometimes SAPDBA offers to update statistics before the Index Information report screen appears, because the statistics data on the table is out-of-date. You can immediately perform an update for the table concerned to get an accurate report on it. For more information about how to identify tables needing an update and how to perform the update, see Update Statistics with SAPDBA.

The entries on the report have the following meaning:

Entry

Meaning

table name

Shows which table the index(es) relate to

type

Shows how the index was created:

  • Unique

Two rows can have the same value for the indexed column(s).
  • Duplicate

Two or more rows can have the same value for the indexed column(s).

levels

Shows how many levels the index has, indicating how large the index is

leaves

Shows how many leaves the index has, indicating how large the index is

fill [%]

Shows approximately how full the index is. Note that duplicate (that is, non-unique) indexes appear with a hyphen in this field, because it would take too long for SAPDBA to derive a fill level.

  1. To see more detailed storage information for a single index, choose one of the numbers on the left of the report. For more information, see Analyzing Index Information with SAPDBA.
  2. For more information about printing the report, see Printing a SAPDBA Report.

Result

You now have a better picture of the storage situation for the indexes of the table in question. For more information if you want to perform a reorganization, see Reorganizing All Indexes of One Table with SADPBA.

 

See also:

Informix documentation