My Oracle Support Banner

Global FreeText Search Performance due to IMPLICIT WILDCARD IN FIND (Doc ID 2404927.1)

Last updated on JULY 22, 2018

Applies to:

Siebel eCommunications - Version 17.4 [IP2017] and later
Information in this document applies to any platform.

Symptoms

On : 17.4 [IP2017] version, System Admin

ACTUAL BEHAVIOR
---------------
Global Search Long running query issue

The free text search provided in IP17, there are long running queries being formed which are causing slowness in db. The queries formed are ((T31.INT_ORG_FLG != 'Y' OR T31.PRTNR_FLG != 'N') AND T31.ACCNT_FLG != 'N')) AND
  ((T31.OU_NUM) LIKE '%XXXXXXX%' OR T31.NAME LIKE '%XXXXXX%'); of this nature and return results in a few minutes. This is a very critical step for us in the journey and hence has a major business impact.

EXPECTED BEHAVIOR
-----------------------


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Just type some account name and selected the in Account from the typeahead that appears on the search


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users facing performance issue for freetext search provided in IP17  .

Changes

 

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!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.