Skip Headers

# Hints

Previous

Next

Oracle lets you specify SQL query additions called hints that can influence how the database server SQL optimizer works. This lets you influence decisions usually reserved for the optimizer. You use hints to specify things such as join order for a join statement, or the optimization approach for a SQL call.

You specify hints using the `DatabaseQuery` method `setHintString`.

For more information, see the following:

- "Database Queries"

- "Oracle Hints"

- Your database Performance Tuning Guide and Reference.