Create Domain Index
A domain index increases the speed of equality queries on encrypted columns. After a table is migrated with column–level IVs in Oracle 9i or higher, domain indexes on the encrypted columns can be created.
Views and triggers are recreated when domain indexes are added or removed from a table.
When a column is unencrypted, the domain indexes are automatically removed.
Domain indexes cannot be created on migrated columns with field-level IVs, large object datatypes, and columns which are migrated to large object datatypes.
To create domain index:
Log on to the CipherTrust Manager GUI.
Click Database Protection to open the application. The Databases screen displays the list of existing database connections, if any.
Click the desired database connection.
Click the Tables link.
On the Authorize Database screen, enter the Database Password to access the tables.
Under the Tables with Encrypted Columns section, click the table for which you want create domain index.
Click Domain Index. The Domain Index Wizard is displayed. Follow the steps to complete the setup.
a. Add Data Settings
b. Preview SQL
c. Perform Operation
Add Data Settings
Enter/select the following details:
Component Description Column Name Name of the column on which domain index is to be created. Action to Take Action to be taken on column.
— Do Nothing: No action is taken on the column.
— Create: Domain index is created on the column.
Index Name Enter Index Name. This field is configurable if action to be taken is Create. Domain Index Enter Domain Index. This field is configurable if action to be taken is Create. Tablespace Name From the drop-down list, select the tablespace Name.
If you want to modify General Info details such as Action to Take, Index Name, and Domain Index, click Edit, update the fields, and click Next.
Preview the SQL code to be executed. This code cannot be modified.
The Perform Operation screen shows the progress of the operation. A message The domain index were successfully created. Close the window to return to the list is displayed on the screen.