Optimizing joins
You can improve a query’s performance by optimizing the joins. To optimize a join, you can specify the cardinality of the join. Specifying the cardinality of the join adds the CARDINALITY keyword to the Actuate SQL query. If your query is based on two or more information objects that are based on different data sources, you can also optimize the joins by specifying join algorithms.
Figure 2-8 shows how to specify the cardinality of a join and how to specify a join algorithm in Joins.
Figure 2-8  

Additional Links:

Copyright Actuate Corporation 2012