Optimizer Hints

This section details special comments you can add to SQL statements to influence the query optimizer, helping you manually select better execution plans for improved performance and query tuning.

Optimizer hints are options available that affect the execution plan.

SELECT Modifiers have been in MariaDB for a long time, while Expanded Optimizer Hints were introduced in MariaDB 12.0 and 12.1.

See Also

• Use optimizer_switch to enable/disable specific optimizations

_{This page is licensed: CC BY-SA / Gnu FDL}