FairCom DB API for C

ctdbSetIndexKeyType

Set the index key type.

Declaration

CTDBRET ctdbSetIndexKeyType(CTHANDLE Handle, CTDBKEY KeyType)

Description

ctdbSetIndexKeyType() sets the key type for this index. Use ctdbAddIndex() to add an index to a table. Use ctdbGetIndexKeyType() to retrieve the Index key type. The valid key types are listed in FairCom DB API definitions.

• Handle [in] the index handle.
• KeyType [in] the key type. See the allowed values in FairCom DB API definitions.

Valid keytype values are:

• CTINDEX_FIXED: Fixed-length key
• CTINDEX_LEADING: Leading-character compression
• CTINDEX_PADDING: Padding compression
• CTINDEX_LEADPAD: Leading and padding compression

Note: Key compression imposes a significant performance impact, especially when deleting records. Use this feature only when absolutely necessary to keep index space requirements to a minimum.

In V11 and later, a new key type, CTINDEX_DFRIDX, has been added to indicate a deferred index.

Another new type, CTINDEX_NOMOD, was added to indicate an index with unmodifiable ISAM and FairCom DB API keys.

Returns

ctdbSetIndexKeyType() returns CTDBRET_OK on success, or FairCom DB API C API error on failure.

See also

ctdbAllocIndex(), ctdbGetIndexKeyType()