Cardinality Considerations

Analytical Views improve performance because they leverage inherent reduction in cardinality as a result of grouping.  For this reason, ensure that the grouping columns have a reasonable reduction in cardinality over the base tables. It is best to avoid using float or integer columns with large number of distinct values in the GROUP BY clause.