Show TOC

Function documentationMDO Indexes

 

You can create indexes on the columns of a persistent MDO table. This allows you to speed up data access on the table. You can create an index by selecting multiple columns of a table and specify a unique constraintt. The sort order (ascending or descending) can be specified for each column.

Features

The attributes are listed in the following table:

Attribute

Description

Index Name

Enter a name

Indexed Columns

Displays the attributes that are selected in In Index column along with the sort order. The attributes are comma separated.

Unique

Indicates the uniqueness of each index

Add

Add a row in Index table

Delete

Delete a row in Index table

Attribute Name

Displays the attributes of the MDO

In Index

Select one or more check boxes

Sort

Choose the sort order for the attribute, Ascending or Descending