Oracle SQL Performance Tuning and Optimization

More about the book

Written by a Senior Database Administrator with thirty years of experience in Oracle RDBMS, this book teaches SQL Tuning for the Oracle Database through a comprehensive process of discovery, analysis, and problem resolution, rather than offering superficial tips. Readers will learn the science behind SQL Tuning, including the FILTERED ROWS PERCENTAGE Cardinality method, determining a query's Driving Table and Join Order, and constructing Query Diagrams, Data Models, and Join Trees. The text covers building and utilizing Count, Filter, and Reconstruction Queries, identifying waste in Query Execution Plans, and understanding Cardinality Divergence by comparing Estimated vs. Actuals. It introduces the ACCESS/FILTER/COVERAGE strategy for indexing Problem Queries and discusses the 2% RULE for analyzing Access and Join methods. The book also classifies queries, explains Hash Join mechanics, and offers strategies for managing Statistics and common issues. Additional features include a chapter on EXADATA, a LAB for demonstrating the cardinality-based tuning process, and twenty-three SQL scripts to simplify SQL Tuning. This resource is designed for those looking to master SQL Tuning from an expert perspective, positioning them as specialists within their organizations.