Examples
The following examples provide details.
Example 1:
The following example creates an index called "x" for the columns ename and age on table employee:
index on employee is x(ename, age)
Example 2:
The following example creates an index called "ename", located on the area referred to by the locationname "remote":
index on employee is remote:ename(ename, age)