Performance Tuning

This category contains 1 post

Tuning Query without Changing Code by Using SQL Plan Baseline

As a DBA most of us have had such experiences, when tuning a SQL statement we found the only way to improve the performance of the SQL is to change the code. The change can be adding/removing hints, changing the order of joins, removing unnecessary function calls, etc. However in reality we all know the … Continue reading