SQL Performance Tuning [Electronic resources]

Peter Gulutzan, Trudy Pelzer

نسخه متنی -صفحه : 124/ 1
نمايش فراداده

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 Averni

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