Home » SQL & PL/SQL » SQL & PL/SQL » How to tune query? (10g)
How to tune query? [message #575163] Sun, 20 January 2013 14:05 Go to next message
piyarustagi
Messages: 38
Registered: January 2011
Member
Hi Guys,
Please suggest how can I tune/ optimize the following query... Thanks a lot in advance. I will really appreciate for your help. It's like small sql queries joined by UNION ALL. I just need some suggestion that what should I use to improve this query? The first part of the query is slow.
Should I use views, stored procedures, temporary tables or hints or something else?
The query is attached.
  • Attachment: query.sql
    (Size: 150.51KB, Downloaded 33 times)

Report message to a moderator

Re: How to tune query? [message #575164 is a reply to message #575163] Sun, 20 January 2013 14:13 Go to previous message
Michel Cadot
Messages: 54239
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
For any performances question, please read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

Report message to a moderator

Previous Topic: Update table with join
Next Topic: Checking values of procedure's parameters
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sat May 25 03:39:24 CDT 2013

Total time taken to generate the page: 0.13382 seconds
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.