SYSOPCLASSES
The sysopclasses system catalog table contains
information about operator classes associated with secondary access
methods. It contains one row for each operator class that has been
defined in the database. The sysopclasses table has the following
columns.
| Column | Type | Explanation |
|---|---|---|
| opclassname | VARCHAR(128) | Name of the operator class |
| owner | VARCHAR(32) | Name of the owner of the operator class |
| amid | INTEGER | Identifying code of the secondary access method associated with this operator class |
| opclassid | SERIAL | Identifying code of the operator class |
| ops | LVARCHAR(2048) | List of names of the operators that belong to this operator class |
| support | LVARCHAR(2048) | List of names of support functions defined for this operator class |
The opclassid value corresponds to the sysams.am_defopclass value that specifies the default operator class for the secondary access method that the amid column specifies.
The sysopclasses table has a composite index on the opclassname and owner columns and an index on opclassid column. Both indexes allow only unique values.