This section of the SDE30_DEF line defines one or more non-spatial index columns. Non-spatial column indices are used to increase the performance of the non-spatial component of queries.
Each index definition is identified by a unique name and has the components shown in the following table.
|
Parameter |
Contents |
|
SDE_INDEX_CONFIG |
The configuration keyword that describes the storage characteristics of the index tables. Example value is DEFAULTS. |
|
SDE_COLUMN_NAME |
A comma-separated list of the columns that make up the index. |
|
SDE_UNIQUE |
A flag to indicate if the index values are unique or not. Acceptable values are N or Y. |
|
SDE_SORT_ORDER |
The sort order of the index. Indicates whether the index returns the records in ascending or descending order. Acceptable values are ASCEND or DESCEND. |
The following example defines an index called countryCapital. The index is ascending and is not unique. The index is built on the columns COUNTRY and CAPITAL. The index table storage characteristics are taken from the dbtune.sde file entries defined by DEFAULTS.
SDE_INDEX countryCapital \ SDE_INDEX_CONFIG DEFAULTS \ SDE_COLUMN_NAME COUNTRY,CAPITAL \ SDE_UNIQUE N \ SDE_SORT_ORDER ASCEND \