Order By Clause Slows Down Query Execution

(Doc ID 1534059.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.4 [21225] and later
Information in this document applies to any platform.
*** Checked for relevance on 31-AUG-2016 ***

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

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