$P Table is Not Being Used for Leading Single Wildcard Search Queries, Affecting Performance
Last updated on NOVEMBER 09, 2011
Applies to:Oracle Text - Version: 184.108.40.206
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms