INDEX example

The following example creates an index based on the last name and first name in a table:

index on upper( LAST_NAME + FIRST_NAME ) tag FULL_NAME

The next example indexes on a customer ID and the order date as the primary key for an Orders table:

index on CUST_ID + dtos( ORDER_DATE ) tag CUST_ORD primary