Create an Index on a TimesTen Table

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 that you want to create an index on and select Index, then Create Index.

You can also right-click the Indexes node and select New Index.

In the Properties tab of the Create Index dialog box, select the table that you want to create an index on from the Table pull-down menu.

In the Type section, select the:

Bitmap indexes are supported in TimesTen 11g or later.

In TimesTen 7.0, a range index is called a T-tree index.

In the Index section, specify the columns that the index is to be defined on. The columns can be selected from the Column Name or Expression pull-down menu. For each indexed column, you can specify whether the column is to be sorted in ascending or descending order from the Order pull-down menu. The default sort order is ascending.

To create a composite index, click the + button to add columns to the index. Click the X button to remove columns from the index.

In the DDL tab of the Create Index dialog box, you can view the CREATE INDEX statement that will be used to create the index.

Click the OK button to create the index.

Related Topics

TimesTen Tasks

SQL Developer Concepts and Usage