Home » RDBMS Server » Performance Tuning » BUFFER SORT
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.

 

 
Previous Topic: different plan output
Next Topic: URGENT:-Full table scan
Goto Forum:
  


Current Time: Thu Mar 28 06:54:16 CDT 2024