The ora:contains() function is easy to use but not a good choice for large datasets or frequent full-text queries because run-time full-text analysis is a very resource-intensive process. Instead, for a large XML dataset, you need to create a full-text index using Oracle Text. Oracle Text is known as Oracle InterMedia Text in Oracle8i. One of the Oracle Text indexes, the CONTEXT index, can be used to enable full-text search.
FIGURE 10-1. Oracle Text indexing process
Figure 10-1 illustrates the Oracle Text indexing process. Each step in the process is configurable.
First, the data is fetched from database tables or external ...