Solving the SQLTuning Problem

BANGALORE, INDIA: For years, commercial database manufacturers have fought an endless battle to improve the performance of inserting, updating, deleting and retrieving information stored in the database. Despite their ongoing efforts and hard work, we have not seen a significant improvement in the performance of most Relational Database Management Systems (RDBMS). Users satill suffer from under-performing SQL statements, and database experts are still spending countles hours tuning SQL statements.

Major deficiencies cause the database's internal SQL optimizer to fail to find a good execution plan for a SQL statement. Two of these deficiencies include inaccurate database statistics and SQL cost estimation of the resources that may be used for the SQL statement.

Click here for more...!