Oracle SQL Tuning and CBO Internals (Oracle In-Focus series)

Features

• Cover Type: Paperback with 300 pages
• Published by: Rampant Techpress April 28, 2004
• Written in: English
• ISBN 10 Number: 0974599336
• ISBN 13 Number: 978-0974599335
• Book Dimensions: 8.9 x 6.8 x 1.1 inches
• Weighs: 1.5 pounds

Product Description
As Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time, this book’s timing is critical as tuning Oracle SQL has become the single most important skill of the Oracle professional. While not appropriate for the beginner, this book allows senior Oracle professionals to explore important internal mechanisms within Oracle and the powerful and complex internals of Oracle SQL execution. Topics include the internals of Oracle cost-based SQL optimizer, SQL execution internals within the library cache, Oracle SQL coding and optimization techniques, and Oracle index internals. Also included is a ready-to-use code depot full of working SQL tuning scripts, which allow for quick optimization of the SQL and indexes inside the Oracle database.


About The Author
Kimberly Floss is the president of the International Oracle Users Group (IOUG) , specializing in Oracle performance tuning and SQL tuning techniques. She has over 15 years of experience in information technology, with specific focus on relational database technology including Oracle, DB2, Microsoft SQL Server, and Sybase. She lives in Chicago.


Reader Reviews
If this book had been sent to market as "'Intro to SQL Tuning with Reprints of Previously Published Material by Various Gurus and Breezy Transition Paragraphs by Kimberly,' editor K. Floss available in Large Print Edition Only" I wouldn't feel so ripped off. In that case, my only complaints would have to do with various inaccuracies. Basically, if you know enough about Oracle to be interested in CBO internals, you probably know everything in this silly little book. Comment | | (Report this)