$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 184.108.40.206 and later
Information in this document applies to any platform.
SELECT/*+DYNAMIC_SAMPLING(0) INDEX(T "DR$NK$X")*/ DISTINCT TOKEN_TEXT
FROM "H"."DR$NK$I" T WHERE TOKEN_TEXT LIKE :lkexpr and
(TOKEN_TYPE = 0 OR TOKEN_TYPE = 4 OR TOKEN_TYPE BETWEEN 16 AND 74)
***value of :lkexpr = "_R"
This has an impact on the performance of such queries.
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