Displaying Index Information

Home | Previous Page | Next Page The Table Option > Displaying Table Information >

Displaying Index Information

Figure 94 shows the kind of information that you see when you select the Indexes option for the cust_calls table. The c_num_dt_ix index is a B-tree index defined on two columns of the cust_calls table. The c_num_cus_ix index is a B-tree index defined on a single column of the cust_calls table.

Figure 94. Display of Index Information

Index name        Owner     Type/Clstr    Access_Method       Columns

c_num_dt_ix       velma     unique/No     B-Tree              customer_num
                                                              call_dtime
c_num_cus_ix      velma     dupls/No      B-Tree              customer_num

The following table shows the meaning of each column in the display.

Display Column: Description
Index Name: The name of the index
Owner: The owner of the index
Type: The index type (unique or duplicate)
Clstr: Indicates whether the index is clustered. (A clustered index causes the table to be physically reordered in the same sequence as the index.)
Access Method: The index access method (such as B-tree or functional)
Columns: The column or columns on which the index is defined

For further information about the types of indexes available on your database server, see your IBM Informix: Performance Guide.

Dynamic Server

You can display information for non-B-tree indexes, including indexes based on user-defined secondary access methods that Dynamic Server permits. For example, the index shown in Figure 95 is based on a Fulltext access method that a DataBlade module provides.

Figure 95. Display of Information for a DataBlade Module Index

Index name       Owner    Type/Clstr    Access_Method         Columns
text_idx         wilma     dupls/No      Fulltext             zone_descr

For information about user-defined access methods, see your DataBlade documentation or the documentation for the access method.

End of Dynamic Server