ALLBASE/SQL Reference Manual (36216-90216)

336 Chapter10
SQL Statements A - D
CREATE INDEX
Example
This unique index ensures that all part numbers are unique.
CREATE UNIQUE INDEX PurchDB.PartNumIndex
ON PurchDB.Parts (PartNumber)
This clustering index causes rows for order items associated with one order to be stored
physically close together.
CREATE CLUSTERING INDEX OrderItemIndex
ON PurchDB.OrderItems (OrderNumber)