6. QUEL and EQUEL Statements : Index Statement--Index a Table : Examples
 
Share this page                  
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)