# Optimizer Hints

Optimizer hints are options available that affect the execution plan.

[SELECT Modifiers](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/select-modifier-hints) have been in MariaDB for a long time, while [Expanded (New-Style) Optimizer Hints](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/optimizer-hints/expanded-optimizer-hints) were introduced in MariaDB 12.0 and 12.1.

## See Also

* [Use optimizer\_switch to enable/disable specific optimizations](https://mariadb.com/docs/server/ha-and-performance/optimization-and-tuning/query-optimizations/optimizer-switch)

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}