Available in versions: Dev (3.20) | Latest (3.19) | 3.18 | 3.17 | 3.16 | 3.15 | 3.14 | 3.13 | 3.12 | 3.11 | 3.10

This documentation is for the unreleased development version of jOOQ. Click on the above version links to get this documentation for a supported version of jOOQ.

OPTION

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

The OPTION hint in SQL Server is used for query level hints.

For example:

SELECT field1, field2
FROM table1
OPTION (OPTIMIZE FOR UNKNOWN)
 
create.select(field1, field2)
      .from(table1)
      .option("OPTION (OPTIMIZE FOR UNKNOWN)")
      .fetch()

Not all of these query level hints include the OPTION keyword, which is why it must be added manually to the OPTION string in jOOQ.

Feedback

Do you have any feedback about this page? We'd love to hear it!

The jOOQ Logo