From the official Oracle Press comes a comprehensive guide to tuning SQL statements for optimal execution. This expert resource explains how to view the internal execution plan of any SQL statement and change it to improve the performance of the statement. You'll get details on Oracle's optimizer modes, SQL extensions, the STATSPACK utility, and a wealth of methods for tuning Oracle SQL statements.
Customer Reviews & Comments
I'm sure that this was a great book in it's day, but it is 5 years old and useful only for firewood. The rule optimizer is not even there anymore. [...]