Chapter 12 DBMS-Specific Features
Index extensions are supported for DB2 v9.x and higher, and are used with indexes on tables that have columns of a structured or distinct type.
The following options are available on the DB2 tab:
| 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 |
| 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 |
| 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 |
| Source key parameters | Specifies the parameter (and its data type) that is associated with the source key column.
Scripting name: SourceKeyParameters |
| 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 |
| Copyright (C) 2008. Sybase Inc. All rights reserved. |
| |