My Oracle Support Banner

Text Index Search Slower Than Splitting The Query (Doc ID 1329514.1)

Last updated on JUNE 21, 2022

Applies to:

Oracle Text - Version 10.2.0.4 and later
Information in this document applies to any platform.

Symptoms


ORIGINAL Query takes 4X more to execute than SPLIT query

ORIGINAL Query:


Time: 00:00:01.59

Compare times:

ORIGINAL Query: 1 min 39 secs
SPLIT Query: 24 secs

ORIGINAL Query takes 4X more to execute than SPLIT query

The original query cannot do so because it has already used the Domain index to satisfy the where clause. And cannot use another index in the same query for order by clause.

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.