Enterprise Edition Home
|
Express Edition Home
|
Previous Page
|
Next Page
Optimizer Directives
In This Chapter
What Optimizer Directives Are
Optimizer Directives That Are Embedded in Queries
External Optimizer Directives
Reasons to Use Optimizer Directives
Guidelines for Using Directives
Preparation for Using Directives
Types of Directives That Are Included in SQL Statements
Access-Plan Directives
Join-Order Directives
Effect of Join Order on Join Plan
Join Order When You Use Views
Join-Plan Directives
Optimization-Goal Directives
Example with Directives
EXPLAIN Directives
Configuration Parameters and Environment Variables for Directives
Directives and SPL Routines
Using External Optimizer Directives
Creating and Saving External Directives
Enabling External Directives
Deleting External Directives
Enterprise Edition Home
|
Express Edition Home
| [
Top of Page
|
Previous Page
|
Next Page
|
Contents
|
Index
]