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