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

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:
- A single arrow moves the selected column or columns to the other list. To select multiple columns, hold down the Shift key while selecting.
- A double arrow moves all the columns from one list to the other list.
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.
- The View tab shows the results of the sort for the selected index.
- The Info tab shows the selected index properties.