Data (Index Keyword)
Specifies a list of properties whose values are to be stored within this index.
To store values of properties within an index, use the following syntax:
Index name On property_expression_list [ Data = stored_property_list ];
name is the name of the index. It is useful to follow a naming convention so that indexes can be easily distinguished from properties. For example, you could include IDX at the end of all index names.
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 indexes 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) ];