Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Sorting causing Performance issues

430601Nov 11 2008 — edited Nov 13 2008

Morning all,

I have written a report based on a materialised view that returns 36,000 rows in about 10 seconds. As soon as I put a sort on just one of the fields, the performance degrades. I have tried sorting it after the results are returned and ogt fed of of waiting so have now written the report again with the sort included at the beginning.

It has now been running for 30 minutes. If the query itself is exactly the same why is there such a hit on performance?

Any help would be greatly appreciated! I am using Disco 10G Desktop

Cheers
Col

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 11 2008

Added on Nov 11 2008

#business-intelligence-applications, #business-intelligence-foundation, #discoverer

6 comments

933 views