Using optimizer hints v16

When you invoke a DELETE, INSERT, SELECT, or UPDATE command, the server generates a set of execution plans. After analyzing those execution plans, the server selects a plan that generally returns the result set in the least amount of time. The server's choice of plan depends on several factors:

  • The estimated execution cost of data handling operations
  • Parameter values assigned to parameters in the Query Tuning section of the postgresql.conf file
  • Column statistics that were gathered by the ANALYZE command

As a rule, the query planner selects the least expensive plan. You can use an optimizer hint to influence the server as it selects a query plan.