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.
Select the name of the table from this drop-down list for which you want to create an index.
Type the name of the index in this field.
Specifies the Locale object to use for determining how to do the sort. Select a Locale from the drop-down list.
Check Unique if you want the combined results of the selected columns to be unique for every row.
Check Case Insensitive if you don't want the sort to match items by case.
Check Sort as Inserted if you want new rows to remain where they were inserted.
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:
Specify the sort order as Ascending or Descending for each column in the Selected list.
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.