Auto Group and Summarize property
The property is used by all queries. This property is useful when considering performance implications of large queries that contain many nested queries. If the property is set to:
- Yes: Cognos applies a DISTINCT clause to the query generated by the query if the model contains text values or the GROUP BY clause if the Query contains numeric data or aggregate functions such as SUM or AVG.
- No: Cognos does not apply DISTINCT or GROUP BY clauses.
In large queries that contain many nested queries, we recommend that you set the property to Yes at the highest level possible. Then set the property to No for all sub-queries.