My Oracle Support Banner

Query and Document Services Performance Issue with AUTO_LEXER (Doc ID 1126248.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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

Symptoms

Query performance tests and queries using CTX_DOC.HIGHLIGHT on Text Index with AUTO_LEXER vs. WORLD_LEXER on database version 11.2.0.1 showed a dramatical performance drop (~ factor 20), i.e. CTX_DOC.HIGHLIGHT with AUTO_LEXER has been tested to be ~20 time slower than using WORLD_LEXER.


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.