Common
Add Indices
Indices are a way for the database system to find records efficiently. Indices must be manually added to System Types.
To add indices:
- Click Common > System Types in Navigation pane.
- Click Tables icon for a System Type.
- Click Indices icon for a table.
-
Click Add.
View the field descriptions for the System Types Table Indices page
- Enter a name in INDEX NAME field.
-
Click UNIQUE INDEX check box to build a unique index.
OR
Click PRIMARY KEY check box to build the index as a primary key for the table.
-
Click CLUSTERED INDEX check box to mark the index as clustered, which is a special index type in SQL Server. Refer to Microsoft SQL documentation on details for clustered indices.
NOTE: CLUSTERED INDEX can be used with PRIMARY KEY to create a clustered or non-clustered primary key.
- Click Save.
-
Click Index Fields for table index.
NOTE: If no records exist, the page displays in Add mode. Otherwise, click Add on the Page toolbar.
View the field descriptions for the System Types Index Fields page
- Select field in column that exists in index from SYSTEM TYPE TABLE FIELD ID list box.
- Enter order of field in index in COLUMN ORDER field.
- Click Save.