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 88 times)
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: 58643
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
Previous Topic: Update table with join
Next Topic: Checking values of procedure's parameters
Goto Forum:
  


Current Time: Fri Aug 01 12:14:49 CDT 2014

Total time taken to generate the page: 0.08838 seconds