CREATE_INDEX_SET

Creates an index set for CTXCAT index types.

Name this index set in the parameter clause of CREATE INDEX when you create a CTXCAT index.

Note: The Oracle Text indextype CTXCAT is deprecated with Oracle AI Database 26ai. The indextype itself, and it’s operator CTXCAT, can be removed in a future release.CTXCAT was introduced when indexes were typically a few megabytes in size. Modern, large indexes, can be difficult to manage with CTXCAT. The addition of index sets to CTXCAT can be achieved more effectively by the use of FILTER BY and ORDER BY columns, or SDATA, or both, in the CONTEXT indextype. CTXCAT is therefore rarely an appropriate choice. Oracle recommends that you choose the more efficient CONTEXT indextype.

Syntax

CTX_DDL.CREATE_INDEX_SET(set_name in varchar2);

set_name

Specify the name of the index set. Name this index set in the parameter clause of CREATE INDEX when you create a CTXCAT index.