1
Introduction
Purpose
SQL tuning is one of the challenging
tasks faced by Database Administrators. It is an interesting and creative, but
at the same time, daunting task. Manual tuning of SQL statements requires
through knowledge of how the statements are executed in the background and experience
to understand suitable access paths to yield better response times. Moreover,
in a typical application, there are just too many SQL statements to tune and
advise the developers.
