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