The following items are typical of the denormalizations that can sometimes be exploited to optimize performance:
- Repeating groups
- Prejoins
- Derived data (fields) and summary tables (column aggregations)
The following items are typical of the denormalizations that can sometimes be exploited to optimize performance: