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
• Cached Query 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
• Specify Optimization Hints in Queries
• FROM Clause Keywords
• Comment Options