Oracle Text (MOSC)

MOSC Banner

Restricting which XPATHs are indexed in XMLType Text Indexes?

edited Sep 7, 2017 9:18AM in Oracle Text (MOSC) 2 comments

Oracle 12.1.0.2 - we have a database that handles a lot of frequently-changing XML documents. We apply Text Indexes to the XMLType columns of various tables as we need the basic 'CONTAINS (...) INPATH (...)' and wordlist 'substring and prefix' features that the index provides for user-queries.

Our current Text Index implementation indexes the entire document (40m+ records), and also applies wordlist 'SUBSTRING_INDEX' and 'PREFIX_INDEX' parameters, which uses a lot of space, much of which is ultimately wasted as most of each document doesn't really need to be indexed. The records are also updated very frequently, and therefore need to be frequently synchronized (every few mins) to prevent user-searches from becoming too stale. We already implement XMLIndexes for fast 'exact-match' searches elsewhere in the application, and restrict which XPATHs these objects index with "PATHS ... ADD/EXCLUDE" parameter, so I'm wondering if there is a similar concept for

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center