Sumário Itens Encontrados: 46IntroductionAims and Target GroupsAn Overview of the Book Acknowledgments Some Thoughts on the Term SQL TuningSQL Tuning: Definitions and ObjectivesSQL TunersOracleDeveloper Database AdministratorMinimum Minimorum on the Subject of the Execution PlanCan You Read Execution Plans? Some Important DetailsSections of the Execution PlanOptimizer Estimations and Costs Runtime StatisticsApproaches to Formal SQL Tuning The Objective: Effective SQL Tuning The Principle: Elimination of Brakes in the Execution PlanThe Method: Analysis of Runtime Statistics in the Execution Plan The Main Criterion: The Runtime Statistic Cardinality The Procedure: An Iterative Process The Guideline: Tuning Without Changing the SQL Statement Bottlenecks in the Execution Plan Local Problems in the Execution Plan A Missing Index A Nonselective Index An Index with a Large Clustering FactorA Sparse Index Nested Loop Join Instead of Hash Join and Vice Versa Global Problems in the Execution Plan Formal Rules for Changing the Table Order in a Join Joins with a Low Number of Hits Joins with a Large Hit Quantity Procedure of Formal SQL Tuning Practical Experience with Formal SQL Tuning Hannoâs Experience Statistics on Problem Categories A Small Synthetic Test Case in Respect of a Nonselective Index Practical Example Victorâs Experience The First Practical Example The Second Practical Example Closing Remarks Application of the Formal Principle for the Analysis of Performance Problems After an Oracle Migration Literature