Default operator classes

Each secondary-access method has a default operator class associated with it. By default, the CREATE INDEX statement associates the default operator class with an index.

For example, the following CREATE INDEX statement creates a B-tree index on the postalcode column and automatically associates the default B-tree operator class with this column:
CREATE INDEX postal_ix ON customer(postalcode)

For more information about how to specify a new default operator class for an index, see User-defined operator classes.


Copyright© 2019 HCL Technologies Limited