SQL Performance Tuning - page 1
- 1
- 2
- SQL Performance Tuning
- SQL Performance Tuning
- Table of Contents
- Copyright
- Preface
- You Don t Know that Your DBMS Is Good ...
- You Know that Even Good Tools Work Better in Skilled Hands ...
- Acknowledgments
- Chapter 1. Facilis Descensus Averni1
- This Subject Is Important
- The Big Eight
- Test Results
- Portability
- Terminology and Expectations
- Generalities
- Chapter 2. Simple Searches
- General Tuning
- Specific Tuning
- Style Notes
- Parting Shots
- Chapter 3. ORDER BY
- General Sort Considerations
- Character Sorts
- Other Options
- Parting Shots
- Chapter 4. GROUP BY
- Refresher
- Optimal GROUP BY Clauses
- Sorting
- Set Functions and Summary Aggregates
- Parting Shots
- Chapter 5. Joins
- Join Plan Strategies
- Avoid the Join Strategies
- Three-Way Joins and Beyond
- Old Style versus ANSI Style
- Parting Shots
- Chapter 6. Subqueries
- Refresher
- Join versus Subquery
- Syntax Choices
- Parting Shots
- Chapter 7. Columns
- How Big Is the Size Factor?
- Characters
- Temporals
- Numbers
- Bits
- Large Objects
- NULLs
- Column Order Within Rows
- Parting Shots
- Chapter 8. Tables
- The Storage Hierarchy
- Heaps
- Clusters
- The Normal Forms
- Views
- Parting Shots
- Chapter 9. Indexes
- Refresher
- B-trees
- Types of Indexes
- Bitmap Indexes
- Other Index Variations
- Index Key Values
- Parting Shots
- Chapter 10. Constraints
- NOT NULL
- CHECK
- FOREIGN KEY
- PRIMARY KEY
- UNIQUE
- Triggers
- Disabling Constraints
- Client Validations
- Redundant SELECT Clauses
- Parting Shots
- Chapter 11. Stored Procedures
- Refresher
- 1
- 2
