Slow Query Performance
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 22.214.171.124  to 8.2.2 SIA [Release V7 to V8]
z*OBSOLETE: Microsoft Windows 2000
Product Release: V7 (Enterprise)
Version: 126.96.36.199 
Database: Oracle 10.1.0.2
Application Server OS: Microsoft Windows 2000 Server SP 4
Database Server OS: Sun Solaris 2.8
This document was previously published as Siebel SR 38-3098027535.
Checked for Relevance on ***Jun 5th 2014**
Checked for Relevance on ** Jan 21st 2016**
Customer have upgraded from Siebel 6.3 to 188.8.131.52.
Performing query on "Order #" with applet search specification "[Order Type] = LookupValue ('FS_ORDER_TYPE', 'Sales Order') OR [Order Type] = LookupValue ('FS_ORDER_TYPE', 'eSales Order')" takes 11 minutes for execution.
But when query on other fields(other than Order #) with same applet search specification execution time is less than 2 seconds.
If search specification on Applets is removed, query on Order # execution time is 5 seconds.
For better understanding, two log files have been attached.
1) Query on Order # with search spec - "with search spec - 5.344 seconds.txt"
2) Query on Order # without search spec - "without search spec - 658.814 seconds.txt"
Bus Comp - "Order Entry - Orders"
Applets - "Order Entry - Order List Applet (Sales)", "Order Entry - Order Form Applet - Entry (Sales)"
How to improve performance for execution of query on order # with applet search spec?
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