Create Index dialog box

Use the Create Index dialog box box to visually create an index for a JDataStore table. To open this dialog box, choose Tools|Create Index in the JDataStore Explorer.

createindex.gif

Table Name

Select the name of the table from this drop-down list for which you want to create an index.

Index Name

Type the name of the index in this field.

Table Locale

Specifies the Locale object to use for determining how to do the sort. Select a Locale from the drop-down list.

Unique

Check Unique if you want the combined results of the selected columns to be unique for every row.

Case Insensitive

Check Case Insensitive if you don't want the sort to match items by case.

Sort as Inserted

Check Sort as Inserted if you want new rows to remain where they were inserted.

Columns

Select which columns to include in the sort. Use the arrow buttons to move columns from the Available list to the Selected list and back as follows:

Selected Column Sort Order

Specify the sort order as Ascending or Descending for each column in the Selected list.

Viewing the results

When you are finished specifying the index criteria, click OK. The index is added to the list of indexes for that table in the tree at the left of the JDataStore Explorer.

Two tabs are now present in the right half of the JDataStore Explorer: View and Info.