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
• Application of RTPC
• Overriding or Disabling RTPC
• 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
• Runtime Plan Choice
• System-Wide Auto-Parallel
• Auto-Tune
• Turning Adaptive Mode Off
• 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
• FROM Clause Keywords
• Comment Options