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

Last updated on JUNE 30, 2010

Applies to:

Oracle Text - Version: 11.2.0.1 and later   [Release: 11.2 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