Altering an Index

You can use the ALTER TABLE statement to add (or change) a primary key constraint to use either a range or hash index.

You cannot alter an index to be transformed from a hash to a range index or from a range to a hash index if it was created with the CREATE INDEX statement.

You can change a primary key constraint to use a range index instead of a hash index with the USE RANGE INDEX clause of the ALTER TABLE statement; you can change a primary key constraint to use a hash index instead of a range index with the USE HASH INDEX of the ALTER TABLE statement. See ALTER TABLE in the Oracle TimesTen In-Memory Database SQL Reference.