Creating indexes

Use the Indexes option to view, create and delete B-tree indexes on the specified table.

1. 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.

   
2. Provide the following values. See the create-index Command topic in the D3 Reference Manual for more information on index creation options.

   Value	Description
   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.

3. Click Create.

   The index is created and displays in the Existing Indexes list.

   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.

   • To delete an index, select the index to delete from the Existing Indexes list and click the Delete button.