Oracle SQL Tuning Pocket Reference Paperback / softback
by Mark Gurry
Paperback / softback
- Information
Description
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..
Information
-
Available to Order - This title is available to order, with delivery expected within 2 weeks
- Format:Paperback / softback
- Pages:100 pages
- Publisher:O'Reilly Media
- Publication Date:05/02/2002
- Category:
- ISBN:9780596002688
Other Formats
- EPUB from £4.40
- PDF from £4.40
Information
-
Available to Order - This title is available to order, with delivery expected within 2 weeks
- Format:Paperback / softback
- Pages:100 pages
- Publisher:O'Reilly Media
- Publication Date:05/02/2002
- Category:
- ISBN:9780596002688