SQL Services Hot Tip: Oracle 10g Query Tuning 28 Apr 2010
|
Have you ever had a query that was written on the fly by an application and found it to be very slow or killing your database? The only way to get around this in the past was to inform the application support vendor and have them rewrite the code to improve the performance.
Well, that is now a thing of the past. In Oracle 10g you can easily solve this problem by using the DBMS_ADVANCED_REWRITE package which allows you as the DBA to transform or customize the queries on the fly to make use of a better query with a better explain plan.
This Hot Tip was provided by Byron, one of our Wellington based Oracle consultants.
|
Click here to return to the news items... |