O'Reilly logo

Oracle Database 11g: Building Oracle XML DB Applications by Jinyu Wang

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Using Oracle Text

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.

Image

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required