SQL Performance Tuning
SQL Performance Tuning
ISBN: 0201791692
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 125
Pages: 125
Authors: Peter Gulutzan, Trudy Pelzer
- 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
- Advantages of Stored Procedures
- Parting Shots
- Chapter 12. ODBC
- Refresher
- SQLPrepare
- Fetch Loops
- Data-Change Statements
- Catalog Functions
- Parting Shots
- Chapter 13. JDBC
- Connections
- Query Prepping
- Result Sets
- Data Changes
- Parting Shots
- Chapter 14. Data Changes
- Logs
- INSERT
- UPDATE
- DELETE
- Ugly Updates
- FETCH and Data Changes
- COMMIT and ROLLBACK
- Parting Shots
- Chapter 15. Locks
- What Is a Lock?
- Isolation Levels
- Index Locks
- Hot Spots
- Optimistic Locking
- The Scan Trick
- Parting Shots
- Chapter 16. Clients and Servers
- Middleware
- Server Processes and Threads
- What Should the Client Do?
- Parting Shots
- Chapter 17. Cost-Based Optimizers
- Cost
- Statistics and Histograms
- EXPLAIN
- Hints
- Parting Shots
- Appendix A. Further Reading
- Appendix B. Glossary
SQL Performance Tuning
ISBN: 0201791692
EAN: 2147483647
EAN: 2147483647
Year: 2005
Pages: 125
Pages: 125
Authors: Peter Gulutzan, Trudy Pelzer