Query hints

Hints provide extra instructions to execute a query. Hints must be placed on the first lines of the query in the first position, before the SELECT or WITH clause. Query hints are optional, and one or more hints may be used. The hint syntax starts with two hyphens followed by an asterisk: –*. Hints are case insensitive, but they are documented with mixed case to distinguish the hint syntax.

We recommend that you use infor.() table functions when available instead of query hints. This best practice should improve Compass performance.