Data (Index Keyword)
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:
-
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.
Details
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.
Default
If you omit this keyword, values of properties are not stored within the index.
Example
Index NameIDX On Name [ Data = Name ];
Index ZipIDX On ZipCode [ Data = (City,State) ];
