Configure SQL Performance Options
- Configure Parallel Query Processing
- System-Wide Parallel Query Processing
- Parallel Query Processing for a Specific Query
- Parallel Query Processing Ignored
- Shared Memory Considerations
- SQL Statements and Plan State
- Using Runtime Plan Choice
- Configure Frozen Plans
- How to Use Frozen Plans
- Frozen Plans After Software Version Upgrade
- Frozen Plans Interface
- %NOFPLAN Keyword
- Exporting and Importing Frozen Plans
- Using Adaptive Mode to Improve Performance
- Working with Cached Queries
- Cached Queries Improve Performance
- Creating a Cached Query
- Literal Substitution
- Cached Query Result Set
- Listing Cached Queries
- Executing Cached Queries
- Cached Query Lock
- Purging Cached Queries
- SQL Commands That Are Not Cached
- Specify Optimization Hints in Queries