Skip to Main Content

Analytics Software

Order by in OBIEE

716024Aug 6 2009 — edited Aug 12 2009
When 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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 9 2009
Added on Aug 6 2009
4 comments
2,455 views