Ebook: SQL Tuning

SQL Tuning; Preface; Audience for This Book; Structure of This Book; Conventions Used in This Book; Comments and Questions; Acknowledgments; 1. Introduction; 1.2. Who Should Tune SQL?; 1.3. How This Book Can Help; 1.4. A Bonus; 1.5. Outside-the-Box Solutions; 2. Data-Access Basics; 2.2. Tables; 2.2.2. Purge Eldest; 2.2.3. Purge, Not by Age; 2.2.4. Complete Purge and Regrowth; 2.3. Indexes; 2.3.2. Index Costs; 2.4. Uncommon Database Objects; 2.4.2. Single-Table Clusters; 2.4.3. Multitable Clusters; 2.4.4. Partitioned Tables; 2.4.5. Bit-Mapped Indexes; 2.5. Single-Table Access Paths.;SQL Tuning author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to unsolvable" problems."