Solving the SQL Tuning Problem - Secrets of the SQL Optimizer

This technical brief provides a detailed technical view into the SQL Optimizer and how it provides a solution for improving SQL statement performance that an internal database management system's SQL optimizer cannot provide. We also see how the SQL Optimizer overcomes the very common and persistent pain of under-performing SQL statements while paradoxically reducing the amount of time usually dedicated to handling poorly performing SQL, regardless of database platform.