Home » SQL & PL/SQL » SQL & PL/SQL » Help Required on SQL tuning (Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production)
Help Required on SQL tuning [message #352805] Thu, 09 October 2008 12:53 Go to next message
dave16884
Messages: 1
Registered: April 2005
Location: India
Junior Member
Background: I have a SQL query on a view that is performing bad.This SQL query is using few views, those views are built on Join condition of 3 tables of which one is a global temporary table.

Need: We need to optimize the performance without changing the view definition or the SQL query (The report gets Query generated by commercially of the shelf tools, so we cant change the SQL queries). Hence for few standard reports we created Outline for those bad performing queries, which is performing good but the problem occurs in many other reports. Is there any way that we can handle this problem Globally for all the reports (not by creating a specific outline for each report SQL query)


Please let me know if any specific information is needed.
Re: Help Required on SQL tuning [message #352808 is a reply to message #352805] Thu, 09 October 2008 13:02 Go to previous message
Michel Cadot
Messages: 64110
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Ah ah ah Laughing
The answer is no.

Regards
Michel
Previous Topic: Q-quote mechanism
Next Topic: SQL Query Problem distinct results
Goto Forum:
  


Current Time: Mon Dec 05 11:03:20 CST 2016

Total time taken to generate the page: 0.17162 seconds