BUFFER SORT [message #65365] |
Tue, 24 August 2004 06:31 |
Sashi
Messages: 22 Registered: January 2004
|
Junior Member |
|
|
I have a query which is hogging CPU Utilization upto an extent of 50% and if the page is hit continuosly it results on outage of the servers.
1)Java prog calls a stored procedure which has the query structure similar to the one structure mentioned below:
a. I have 4 inline views int he query before i get the final b. output.Out of which 2 inline views are formed by UNION ALL with 12-14 tables each. c. I also have a sort on around 4 cols.
I observed that BUFFER SORTING is also used in the execution plan.
At this point I cant think of Design change to form one single table out of 12-14 tables with flag indicating the type of data.
What best I can do to improve the performance of this query. tried with the HINTS but to notice only negligible performance improvement.
Hoping to get some information on this.
|
|
|