Index extensions are supported for DB2 for Common Server v9.x and higher, and are used with indexes on tables that have columns of a structured or distinct type.
|
Property |
Description |
|---|---|
|
Owner |
Specifies the index extension schema. Scripting name: Owner |
|
Parameters |
Specifies a list of parameters (with data types) that is passed to the index extension at CREATE INDEX time to define the actual behavior of this index extension. Scripting name: IndexExtensionParameters |
Source key parameters |
Specifies the parameter (and its data type) that is associated with the source key column. Scripting name: SourceKeyParameters |
|
Key generation function |
Specifies how the index key is generated using a user-defined table function. Multiple index entries may be generated for a single source key data value. Scripting name: KeyGenerationFunction |
|
Parameter |
Specifies parameters for the key generation function. Scripting name: KeyGenerationFunctionParameters |
Target key parameters |
Specifies the target key parameters that are the output of the key generation function specified on the GENERATE KEY USING clause. Scripting name: TargetKeyParameters |
Search methods |
Specifies the list of method details of the index search. Each detail consists of a method name, the search arguments, a range producing function, and an optional index filter function. Scripting name: SearchMethods |