Order By Clause Slows Down Query Execution
(Doc ID 1534059.1)
Last updated on AUGUST 27, 2018
Applies to:Siebel CRM - Version 18.104.22.168  and later
Information in this document applies to any platform.
*** Checked for relevance on 31-AUG-2016 ***
*** Checked for relevance on 27-AUG-2018 ***
We are experiencing some slow down in Siebel application and after analysis we found out that the problems seems to be related to some order by clause added to the sql statement.
Currently we find out that the order by clause were found on the following table.column and relatives BC:
S_ORDER_ITEM.LN_NUM, this is related to the searchspec on the "Order Entry - Line Items.Line Number" field;
S_ORDER_POSTN.ORDER_DT, this is related to the searchspec on the "Order Entry - Orders.Order Date" field;
S_ORDER_POSTN.POSTN_ID, this is related to the "System sort spec: Sales Rep Sort Optimization InterField" as per statement attached, also on "Order Entry - Orders" BC, but we don't know how it is added.
In attachment both single query and log from which we extracted them can be found, also we have added SIFs of the BC mentioned above from the Siebel Tools.
We would like your support to understand how to remove this order by and if it is right to remove them.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document