Physical Modeling › Teradata Physical Property Editors › Define a Teradata Index › Specify Options for a Teradata Index

Specify Options for a Teradata Index

Use features on the Options tab of the Table Index or Join Index editors to specify if the index is a primary or secondary index, and additional options.

To specify options for a Teradata index

1. Click Indexes, Table or Join Index on the Model menu.

   The Table or Join Index Editor opens.

2. Click the Options tab and work with the following options:

   Primary index

   Specifies that the index is the primary index. If this check box is not selected, then the index is a secondary index.

   Maintain Logical Row Id

   Specifies whether to maintain row ids for logical rows of the table index.

   Order By

   Specifies how the rows are ordered. Select from the drop-down list. Valid values are: Hash, or Value.

   Generate As Constraint

   Specifies whether to generate the table index as a constraint.

   Constraint Name

   Specifies the constraint name associated with the table index.

   Partition Expression

   Specifies the expression used to partition the primary index. This property only displays if the index is defined as the primary index.

   Click Close.

   The Index editor closes.