My Oracle Support Banner

$P Table is Not Being Used for Leading Single Wildcard Search Queries, Affecting Performance (Doc ID 1370538.1)

Last updated on JANUARY 06, 2020

Applies to:

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

Symptoms

A search with a leading underscore wildcard like "_R" is not optimized by neither the substring nor prefix indexing attributes and following statement is seen in sql trace file.


This has an impact on the performance of such queries.

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