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:
Indicate that a table in a join is optional.
Specify the cardinality of a join.
For query optimization hints to take effect, you must create join conditions with the ON clause, not the WHERE clause.
Indicate that a table in a join is optional.