Create Index

Schema

Selects the Schema to create the index. Default: Schema created current connection

Name

Enters the name of the index to be created.

Type

Selects the type of the index.

• Non-Unique

• Unique

• Bitmap

Schema

Schema list of database is shown. Default: Schema created current connection

Table

Displays a list of selected Schema subtables.

Select Columns

Selects a column to create an index from among the columns of the selected table. The detailed operation is the same as Create Table > Indexes tab. Indexes

Key Compression

Selects whether to compress the key.

In case of Prefix Key, it is activated when Compress is selected.

• Prefix Key: Selects the top Unsigned Integer of the Index Key Column, which is used to compress the duplicate parts within the Index Leaf Block.

Degree of Parallelism(DOP)

Refer to the Create Table > Storage tab. Storage

Invisible

Selects whether Optimizer considers this index.

Reverse

Selects whether to store the byte order of the Index Block in reverse except for the ROWID.

Online

Selects whether to allow DML during the creation of index.

Compute Statistics

Selects whether to collect index statistics information immediately after index creation.

Unusable

Sets whether to use the index or not.

TDE-Range Scan

Sets whether to perform a range scan using the indexes in the encryption table.

Storage Setting

Refer to the Create Table > Storage tab. Storage

Partition

Selects the partitioning type.

• None(Default): No setting value

• Global Range

• Global Hash

• Local

Last Partition Column

Selects the last column of the partitioning key.

A list of the selected columns appears on the Columns tab.

Setting

Detailed settings for each partitioning type.

For detailed actions and fields by type, refer to the Create Table -Partition tab. Partition