Which of the following can result in poor report performance?

Understanding Joins: Outer joins and cross joins often result in large intermediate result sets. This can slow down query performance due to the increased data processing required.

Outer Joins: These include rows that do not have matching keys in the joined tables, which means more data to process and potentially more I/O operations.

Cross Joins: These produce Cartesian products of the involved tables. If the tables are large, the resulting dataset can be enormous, leading to significant performance degradation.

Cognos Documentation: The IBM Cognos Analytics V11.1.x documentation advises optimizing join conditions and limiting the use of complex joins such as outer and cross joins to enhance performance.