Learn to hypercharge your SQL performance with Oracle's Cost-Based Optimizer! By drawing from the combined expertise of the world’s leading Oracle experts, it has been possible to create this indispensable guide to Oracle SQL. Tuning Oracle SQL is the single most important skill of the Oracle professional, and Oracle professionals are challenged to create SQL statements that will support thousands of concurrent executions with sub-second response time. This landmark text focuses on advanced Oracle SQL internals and Oracle indexing management. With combined experience of over a century, the world’s best Oracle authors now share their secrets for Turbocharging Oracle SQL execution. This is a super-advanced book for the senior Oracle professional and it is not appropriate for the beginner. The test explores important internal mechanisms within Oracle and illustrates 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. Best of all, this text comes with a ready-to-use code depot that is full of working SQL tuning scripts. By leveraging on the expertise of the world's leading Oracle experts, you can quickly optimize the SQL and indexes inside your Oracle database.

* Hypercharge your SQL Performance * See inside the Oracle Cost-Based Optimizer * Learn the experts' secrets for Turbocharging Oracle SQL * Receive ready-to-run scripts to tune your Oracle SQL * Tune your library cache for super-fast SQL parsing * Understand the internals of Oracle indexing * See when to use Oracle bitmap indexes * Explore the internals of SQL execution * Understand optimizer plan stability (stored outlines) * See how hints can change SQL execution plans * Understand multi-level index partitioning * Learn why database blocksize is critical for Oracle indexes

About the Author:

 

Kimberly Floss

Kimberly Floss is one of the USA's most respected Oracle Database Administrators and President of the International Oracle Users Group (IOUG). With more than a decade of experience, Kimberly specializes in Oracle Performance Tuning and is a respected expert in SQL tuning techniques. She is an active member of the Chicago Oracle User Group, and the Midwest Oracle User Group, in addition to the IOUG. Kimberly Floss has over 15 years of experience in the Information Technology Industry, with specific focus on relational database technology, including Oracle, DB2, Microsoft SQL Server, and Sybase. She holds a Bachelors of Science Degree in Computer Information Systems from Purdue University, specializing in Systems Analysis and Design, and an MBA with emphasis in Management Information Systems from Loyola University. Kimberly has extensive experience performing as a DBA on Mainframe, Unix and Windows-based systems, as well as managing DBA teams supporting multiple database platforms. She also works as an Adjunct Professor, teaching SQL Programming / Database Administration at a local community college. A popular presenter at International Oracle conferences, Kimberly lives in the Chicago-land area, with her husband, son, and two cats.

Table of Contents:
 

Chapter 1 – Introduction to SQL tuning   The evolution of Oracle SQL   Oracle SQL features         plan stability        materialized views        Oracle10g SQL tuning advisory utilities Oracle blocksize & performance - Robin Schumacher (Rampant content)   Chapter 2 - Cost based SQL optimizer Cost-Based Optimization: Whys and Hows – Rick Greenwald The Importance of Histograms with the Cost-Based Optimizer - Joe Johnson Internals of the cost-based optimizer – Pierre Cassidy SQL tuning Tips - Don Burleson   CBO statistics with dbms_stats - Burleson (Rampant content)   Chapter 3 – SQL execution internals An In-Depth Look at Oracle’s Correlated Subqueries - Richard Earp and Sikha Bagui Oracle’s Joins - Richard Earp and Sikha Bagui Internals of Oracle Hints - Jonathan Lewis   Using hash joins   Chapter 4 - Oracle SQL extensions for performance   Oracle analytic functions   Materialized Views   Stored Outlines   Oracle10g new SQL language features   Oracle10g automatic database diagnostic management (ADDM)

Chapter 5 - SQL coding techniques for high performance SQL Analysis Made Easy - Using New Performance Views in Oracle9i to Identify Problem SQL - Robin Schumacher Analytic functions – Jonathan Lewis SQL*Net Diagnostics and Performance Tuning - Serg Shestakov and Dmitry Petrov Advanced analytical SQL functions – Pierre Cassidy SQL Perfection Checklist: Step---Step Methods for Creating High-Quality Database Code - Robin Schumacher Index column order does matter – Mike Ault Using external tables in Oracle9i – Mike Ault

Material in this text is Copyrighted (c) by Auerbach Publishing, all rights reserved.   Used with permission.