Supplying an operator class for a secondary access method

To supply an operator class for a secondary access method, complete the following steps:

  1. Write support and strategy functions for the operator class if no existing functions suit the data types that the access method indexes.
  2. Register each new support and strategy function with the CREATE FUNCTION statement that includes the NONVARIANT modifier.
  3. Assign the strategy and support functions to operator classes with the CREATE OPCLASS statement.
  4. Assign an operator class as default to the secondary access method with the ALTER ACCESS_METHOD statement.
Parent topic: Specify an operator class
Copyright© 2019 HCL Technologies Limited