Home » SQL & PL/SQL » SQL & PL/SQL » Tuning a query (10g)
Tuning a query [message #385734] Tue, 10 February 2009 21:16 Go to next message
user71408
Messages: 585
Registered: November 2007
Location: NE
Senior Member

Hi
We are having one query that is having order by clause. If we run with order by then it takes 70-80 min to execute and without order by it takes 1-2 min.
We cann't remove order by because of business requirements.
Please suggest me any solution except index, hints (already there).

Thanks and regards
Re: Tuning a query [message #385735 is a reply to message #385734] Tue, 10 February 2009 21:20 Go to previous messageGo to next message
BlackSwan
Messages: 25033
Registered: January 2009
Location: SoCal
Senior Member
>Messages: 411
& you continue to NOT follow Posting Guideline.
I refuse to reward this type of behavior with answers.
Re: Tuning a query [message #385783 is a reply to message #385734] Wed, 11 February 2009 00:49 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
This is a "problem" that has been answered many times.
Compare the time it takes to get ALL the records, not just the first few and you will find out that the order by isn't that much slower.
Re: Tuning a query [message #385875 is a reply to message #385734] Wed, 11 February 2009 11:28 Go to previous messageGo to next message
dr.s.raghunathan
Messages: 540
Registered: February 2008
Senior Member
hi,

Quote:
hints (already there).


i am not able to locate the hints on performance problem. Atleast provide us table structure and data population statistics with triggers if any. Interesting to research to know the bugs.
yours
dr.s.raghunathan
Re: Tuning a query [message #385878 is a reply to message #385875] Wed, 11 February 2009 11:56 Go to previous message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
The answer that is possible with that information: Buy a faster machine.
Previous Topic: Storing image in database
Next Topic: Problems Wrapping package with pipelined functions
Goto Forum:
  


Current Time: Sat Dec 03 01:22:21 CST 2016

Total time taken to generate the page: 0.08361 seconds