A report developer or business user uses an information object to create an Actuate SQL query. When you create the information object, you can provide hints that help to optimize the query. Specifically, you can:
For query optimization hints to take effect, you must create join conditions with the ON clause, not the WHERE clause.
