find the best resource

Oracle SQL Tuning Pocket Reference

Mark Gurry

resource info
Oracle SQL Tuning Pocket Reference redirect to download page

One of the most important challenges faced by administrators and Oracle developers is the need to tune statements so that they execute efficiently. In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. Mark provides a number of handy SQL tips, discusses the use of the DBMS_STATS package to manage database statistics, and shows you how to use outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify.