Data

Specifies a list of properties whose values are to be stored within this index.

Usage

To store values of properties within an index, use the following syntax:

Index name On property_expression_list [ Data = stored_property_list ];

Where stored_property_list is either a single property name or a comma-separated list of properties, enclosed in parentheses.

This keyword specifies a list of properties whose values are to be stored within this index.

You cannot use this keyword with a bitmap index.

Refer to the documentation on indices for more details.

If you omit this keyword, values of properties are not stored within the index.

Index NameIDX On Name [ Data = Name ];

Index ZipIDX On ZipCode [ Data = (City,State) ];