Query and Document Services Performance Issue with AUTO_LEXER

(Doc ID 1126248.1)

Last updated on FEBRUARY 13, 2018

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

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