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 165 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: 65150
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: Using Nested Table (merged)
Next Topic: Difference between Object types and collection types
Goto Forum:
  


Current Time: Mon Aug 21 14:53:24 CDT 2017

Total time taken to generate the page: 0.05158 seconds