• See large image

  Oracle SQL Tuning Pocket Reference (Paperback) By (author) Mark Gurry

  

  $9.46 - Save $2.47 20% off - RRP $11.93 Free delivery worldwide (to United States and
  all these other countries) Usually dispatched within 48 hours Add to basket | Add to wishlist |

  Short Description for Oracle SQL Tuning Pocket ReferenceIn this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers offering SQL tuning tips and solutions to many common problems of both rule-based and cost-based optimisers.
  Full description

  • Publisher: O'Reilly Media, Inc, USA
  • Published: 05 December 2001
  • Format: Paperback 100 pages
  • See: Full bibliographic data
  • Categories: Database Programming | Programming & Scripting Languages: General | Databases | Oracle
  • ISBN 13: 9780596002688 ISBN 10: 0596002688
  • Sales rank: 288,425

• Oracle Data Dictionary Pocket Re...

  

  Add to basket $9.46 - Save $2.47 20% off - RRP $11.93

• Oracle SQLPlus Pocket Reference

  

  Add to basket $9.46 - Save $2.47 20% off - RRP $11.93

• Oracle PL/SQL Programming

  

  Add to basket $60.20 - Save $25.65 29% off - RRP $85.85

• MySQL Pocket Reference

  

  Add to basket $14.25 - Save $4.04 22% off - RRP $18.29

• PHP Pocket Reference

  

  Add to basket $9.46 - Save $2.47 20% off - RRP $11.93

Full description for Oracle SQL Tuning Pocket Reference

• In this book, Mark Gurry shares his in-depth knowledge of Oracle's SQL statement optimizers. Mark's knowledge is the result of many hard-fought tuning battles during his many years of providing Oracle tuning services to clients. Mark provides insights into the workings of the rule-based optimizer that go well beyond what the rules tell you. He also provides solutions to many common problems that occur with both the rule-based and cost-based optimizers. In addition to the specific problem/solution scenarios for the optimizers, the book provides a number of SQL tuning tips. It discusses the various optimizer hints, telling you when they can be used to good effect. Finally, it discusses the use of the DBMS_STATS package to manage database statistics, and the use of outlines to specify execution plans for SQL statements in third-party applications that you can't otherwise modify..