Create an etx index

To create an etx index, you specify the etx access method in the USING clause of the CREATE INDEX statement. You specify the operator class right after specifying the indexed column.

You must create an etx index for each text column you plan to search. You cannot alter the characteristics of an etx index after you create it. Instead, you must drop the index and recreate it with the desired characteristics.