Query Taking More Than 3 Seconds To Execute On A Pick Applet
Last updated on JANUARY 10, 2017
Applies to:Siebel CRM - Version 188.8.131.52.6 [IP2014] and later
Information in this document applies to any platform.
The query was taking time, when resulting SQL was analyzed it was found that as by default siebel does a wildcard search this was taking time.
For example if an Account with name - 'Ant Food Company' was searched, internally the SQL where clause resulted in - T25.ACCNT_NAME LIKE 'Ant Food Company*'
This was taking time to search for all similar named accounts.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms