|
Paper
Presentation
Abstract
Oracle8i Release 3 (8.1.7) introduced the
CTXCAT type index, adding features such as transactional synchronization
of an Oracle Text index and a more “web-like” set
of search operators. The CTXCAT type index also supports better
performance of mixed queries (queries that have an
Oracle Text predicate to query a text column, and another
predicate to query a structured data column). The mixed queries
performance boost is made possible through the use of index
sets (objects that hold sets of ordered lists of columns
from the indexed table), which are specified in the PARAMETERS
clause of a CREATE INDEX statement. This session presents
a quick overview of Oracle Text and CONTEXT indexes, and then
introduces index sets and mixed queries.
| Year |
Venue |
Title |
| 2002 |
NYOUG |
More Oracle Text Tips |
|
