Summary

---

Much of the power in BusinessObjects lies in its robust query capabilities. It can handle complex database schemas by allowing you to generate multiple SQL statements to present one seamless report. In some cases, such as multipass SQL, you may never realize this happens. In other queries, you may explicitly combine queries with a UNION operator. As you create complex queries, be aware that queries may run slower and you should ideally test your query logic with small data sets. In some cases, there is no way around the performance issues; it’s a complex business question answered with complex SQL. In other instances, you may be able to construct the query in ways that help the processing, or the DBA may be able to do some additional tuning.

---