The INDEX instruction creates a new index.
or by specifying a typed parameter referring to the corresponding key field:
The INDEX instruction adds a new index by an ordered list of fields of a certain table. The list must contain at least one property. The table that the index should be built for is determined by the first property in the list. Also, the parameters passed to this property are used to determine the correspondence of the parameters to the key fields of the table. Accordingly, all other properties in the list should have the same number of parameters and be stored in the same table as the first property. The parameters specified in the list will correspond to the key fields of the table.
The ID of the property that should be stored in the table for which the index is being created.
param1, ..., paramN
A list of property parameters. Each element of the list is a typed parameter.
A typed parameter that determines the key field of the table.
INDEX customer(Order o);
date = DATA DATE (Order);
INDEX date(Order o), o;
INDEX name(Sku s), price(s, DATE d), d;