Forum Stats

  • 3,851,925 Users
  • 2,264,053 Discussions
  • 7,904,906 Comments

Discussions

Order by in OBIEE

716024
716024 Member Posts: 66
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.
Tagged:

Answers

This discussion has been closed.