We have updated the Support page with more information aiding users to get the best performance out of Anchor Modeling. There are four key features of a database engine that help produce the best possible performance; table elimination, clustered indexes, foreign keys and statistics.
Read this in order to learn how:
- Indexes and statistics needs to be properly maintained as information is added.
- Adding information may be sped up by temporarily deferring indexes and keys.
- Full table elimination can only be achieved when foreign keys are declared and queries carefully designed.
- Fresh statistics help the query optimizer pick the optimal join order, starting with the smallest intermediate result set and continuing progressively with as few rows as possible through the joins.