Hints

Applies to ✅ Open Source Edition   ✅ Express Edition   ✅ Professional Edition   ✅ Enterprise Edition

A variety of RDBMS support hints, which are vendor specific instructions to the optimiser, telling it what algorithms or meta data usage should be enforced / prevented. Typically, hints are used to enforce hash joins, nested loop joins, etc. or to enforce / prevent index access.

In most cases, you should not need to hint the optimiser, as it can be reasonably expected to make the right decisions on your behalf. But every now and then, it does not, and in those cases, hints can be useful (still, do check if your statistics are up to date, if you have all the meta data you should have, etc.)

jOOQ supports the most common hints for the following database products:

Table of contents

4.14.1.

MySQL hints

4.14.1.1.

Index hints

4.14.1.2.

STRAIGHT_JOIN

4.14.1.3.

Oracle style hints in MySQL

4.14.2.

Oracle hints

4.14.3.

SQL Server hints

4.14.3.1.

WITH

4.14.3.2.

OPTION