Managing Indexes

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:

  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.

    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.

    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

    Record Locks

    General Table Properties

    Usage Table Properties

    Statistics Table Properties

    Listing Servers

    Flash Shared Code

    Checking Overflow

    Running a Hash Test

    Resizing Files