Home > SQL Developer: TimesTen Tasks > Create an Index on a TimesT...
You can create a range index or a bitmap index on a regular table or on a cache table.
To create an index, click the + to the left of the Tables node to view the list of tables. Then right-click the name of the table to create an index on and select Index, then select Create Index.
You can also right-click the Indexes node and select New Index.
In the Properties tab of the Create Index dialog, locate the Table drop-down menu. From this menu, select the table for the index.
For Type:
To create a non-unique range index, choose Non-unique
To create a unique range index, choose Unique
To create a bitmap index, choose Bitmap
For information about the different types of indexes supported in TimesTen, see "CREATE INDEX" in the Oracle TimesTen In-Memory Database SQL Reference.
In the Index section, specify the columns for the index. The columns can be selected from the Column Name or Expression drop-down select list. For each indexed column, from the Order select list, you can specify whether the column is to be sorted in ascending or descending order. The default sort order is ascending.
To create a composite index, click + to add columns to the index definition. Click X to remove columns from the index definition.
In the DDL tab of the Create Index dialog, you can view the CREATE INDEX statement used to create the index.
Click OK to create the index.
Related Topics