Oracle SQL Tuning & CBO Internals View Larger Image | Kimberly Floss
Rampant TechPress, Paperback, Published April 2004, 340 pages, ISBN 0974599336 | List Price: $27.95
Our Price: $17.95
You Save: $10.00 (36% Off)
| | | Availability: Out-Of-Stock |
Be the First to Write a Review and tell the world about this title!People who purchase this book frequently purchase: Books on similar topics, in best-seller order:Books from the same publisher, in best-seller order:
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.
Key Features:
- 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
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
The cost-based optimizer - The Basics
Cost-Based Optimization: Whys and Hows – Rick Greenwald
Internals of the Cost-Based optimizer – Pierre Cassidy
The Importance of Histograms with the Cost-Based Optimizer - Joe Johnson
SQL tuning Tips - Don Burleson
CBO statistics with dbms_stats - Burleson (Rampant content)
Compute vs. Estimate
Conclusion
Chapter 3 – SQL execution internals
Oracle Hints
Internals of Oracle Hints - Jonathan Lewis
An In-Depth Look at Oracle’s Correlated Subqueries - Richard Earp and
Sikha Bagui
Oracle’s Joins - Richard Earp and Sikha Bagui
Using hash joins
Increasing RAM sorting
Conclusion
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
About the Author
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 Bachelor's 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 Chicagoland area with her husband, son, and two cats
|
