Step 3 Create the CTXCAT Index

Create the combined catalog index on the AUCTION table with CREATE INDEX as follows:

CREATE INDEX auction_titlex ON AUCTION(title) INDEXTYPE IS CTXSYS.CTXCAT PARAMETERS ('index set auction_iset');

Figure 2-1 shows how the CTXCAT index and its sub-index relates to the columns.

Figure 2-1 Auction table schema and CTXCAT index

Description of "Figure 2-1 Auction table schema and CTXCAT index"