Order by in OBIEE
716024Aug 6 2009 — edited Aug 12 2009When a request is given in OBIEE presentation server,it is throwing the query with a "Order By" clause .This sorting operation takes a long time to execute in the database.This sorting is hapenning even if we didnot mention any sorting in the view in the request.Pls suggest how this "Order By" clause can be avoided in OBIEE queries.
Also pls note:
1.In Database properties of RPD,ORDER_BY_COLUMNS_IN_SELECT_SUPPORTED is not checked.
2.In Logical Column Properties "Sort Order Column" is defaulted to "None".I dont know if this have anything to do with the Order By Clause.