Performance Reference
An Examination of the Performance Features in the Database Engine
The purpose of this chapter is to explain in detail the optimizations used in the database engine, and how to best take advantage of them in your SQL statements.
This chapter contains complex technical material and is intended for expert-level SQL users. For definitions of the technical terms used in this chapter, see
Terminology
.
•
Restriction Analysis
•
Restriction Optimization
•
Push-Down Filters
•
Efficient Use of Indexes
•
Temporary Table Performance
•
Row Pre-fetch
•
Terminology