Accessing strategy functions for a multiple-column key

About this task

To access strategy functions for a multiple-column key:

Procedure

  1. Call the mi_key_nkeys() accessor function to determine the number of columns in the key.
  2. Call the mi_key_opclass_nstrat() function to determine the number of support functions for a single key column.

    If the access method needs every column in the key, use the return value from mi_key_nkeys() as the number of times to execute mi_key_opclass_nstrat().

  3. Call the mi_key_opclass_strat() accessor function to extract one support function name.

    Use the return value from mi_key_opclass_nstrat() as the number of times to execute mi_key_opclass_strat().

Results

To retrieve all the strategy functions, substitute mi_key_opclass_nstrat() for mi_key_opclass_nsupt() and mi_key_opclass_strat() for mi_key_opclass_supt() in Extracting support functions for a multiple-column index key.