SQL Performance Tuning [Electronic resources]

Peter Gulutzan, Trudy Pelzer

نسخه متنی -صفحه : 124/ 1

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 Averni

This Subject Is Important

Terminology and Expectations

Chapter 2. Simple Searches

Specific Tuning

Chapter 3. ORDER BY

General Sort Considerations

Character Sorts

Chapter 4. GROUP BY

Optimal GROUP BY Clauses

Set Functions and Summary Aggregates

Chapter 5. Joins

Join Plan Strategies

Avoid the Join Strategies

Three-Way Joins and Beyond

Old Style versus ANSI Style

Chapter 6. Subqueries

Join versus Subquery

Chapter 7. Columns

How Big Is the Size Factor?

Column Order Within Rows

Chapter 8. Tables

The Storage Hierarchy

The Normal Forms

Chapter 9. Indexes

Types of Indexes

Other Index Variations

Index Key Values

Chapter 10. Constraints

Disabling Constraints

Client Validations

Redundant SELECT Clauses

Chapter 11. Stored Procedures

Advantages of Stored Procedures

Chapter 12. ODBC

Data-Change Statements

Catalog Functions

Chapter 13. JDBC

Chapter 14. Data Changes

FETCH and Data Changes

COMMIT and ROLLBACK

Chapter 15. Locks

What Is a Lock?

Isolation Levels

Optimistic Locking

Chapter 16. Clients and Servers

Server Processes and Threads

What Should the Client Do?

Chapter 17. Cost-Based Optimizers

Statistics and Histograms

Appendix A. Further Reading

Appendix B. Glossary