pg_hint_plan 1.7

• Synopsis
• Description
  • Basic Usage
• The hint table
  • Types of hints
    • Hints for Scan methods
    • Hints for Join methods
    • Hints for Joining order
    • Hints for Row number corrections
    • Hints for parallel plans
    • GUC parameters set during planning
  • GUC parameters for pg_hint_plan
• Installation
  • Building binary module
  • Installing from a binary package
  • Loading pg_hint_plan
• Uninstallation
• Details in hinting
  • Syntax and placement
  • Using with PL/pgSQL
  • Upper and lower case handling in object names
  • Escaping special characters in object names
  • Distinction between multiple occurences of a table
  • Underlying tables of views or rules
  • Inheritance
  • Hints in multistatements
  • VALUES expressions
  • Subqueries
  • Using IndexOnlyScan hint
  • About NoIndexScan
  • Parallel hints and UNION
  • Setting pg_hint_plan parameters by Set hints
• Errors
  • Syntax errors
  • Incorrect Object definitions
  • Redundant or conflicting hints
  • Nested comments
• Functional limitations
  • Influence of planner GUC parameters
  • Hints trying to enforce non-executable plans
  • Queries in ECPG
  • Query Identifiers
• Requirements
  • See also
  • References
• Hint list