SQL Hints ​

Availability ​

This feature is available since openGauss 1.1.0.

Introduction ​

SQL hints can be used to override execution plans.

Benefits ​

Improves SQL query performance.

Description ​

In plan hints, you can specify a join order; join, stream, and scan operations, the number of rows in a result, and redistribution skew information to tune an execution plan, improving query performance.

Enhancements ​

None.

Constraints ​

None.

Dependencies ​

None.