Order By Clause Slows Down Query Execution
Last updated on MARCH 02, 2017
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 ***
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.
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