Use the Indexes option to view, create and delete B-tree indexes on the specified table. See the create-index Command topic in the D3 Reference Manual for more information on index creation.
To create an index:
Right-click the Data Level table on which to create the new index from the Domain Explorer and select the Indexes option.
The Indexes dialog box displays.
Provide the following values. See the create-index Command topic in the D3 Reference Manual for more information on index creation options.
Create Index |
Specifies the index A-correlative. |
|
Create Options |
Select any of the available options: |
|
Progress |
Displays a progress bar indicating the progress of the index build. This option may slow down the build because the server returns periodically to indicate its progress. Without this option, the build proceeds silently on the server. |
|
Overwrite |
If the index already exists, this option specifies to overwrite the index without prompting for confirmation. |
|
Unicode |
This check box will be checked if the associated data is Unicode data. Note that this value cannot be changed (unchecked). |
|
Index Type |
Select the appropriate option: |
|
Default |
Creates standard indexes. |
|
Numeric |
Creates numeric indexes. |
|
Floating Point |
Creates floating-point indexes. |
Click Create.
The index is created and displays in the Existing Indexes list.
To delete an index, select the index to delete from the Existing Indexes list and click the Delete button.
NOTE |
Indexes listed in the in the Existing Indexes list can be rebuilt or deleted: To rebuild an index, double-click the index to rebuild from the Existing Indexes list to display the index name in the Create Index text box. Then select the Overwrite option and click the Create button. See the indexer Command in the D3 Reference Manual for more information on rebuilding indexes. |
See Also