Order By Clause Slows Down Query Execution (Doc ID 1534059.1)

Goal

Customer:
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.
 

Solution

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