Add an Oracle-style hint to the select clause.
Example:
DSLContext create = DSL.using(configuration);
create.select(field1, field2)
.hint("/*+ALL_ROWS*/")
.from(table1)
.execute();
You can also use this clause for any other database, that accepts hints
or options at the same syntactic location, e.g. for MySQL's
SQL_CALC_FOUND_ROWS
option:
create.select(field1, field2)
.hint("SQL_CALC_FOUND_ROWS")
.from(table1)
.fetch();
The outcome of such a query is this:
SELECT [hint] field1, field2 FROM table1
For SQL Server style table hints, see
Table#with(String)