Help Required on SQL tuning [message #352805] |
Thu, 09 October 2008 12:53  |
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.
|
|
|
|