Four features for performance

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.

Published by

Lars Rönnbäck

Co-developer of the Anchor Modeling technique. Programmer of the online modeling tool. Site maintainer. Presenter and trainer.

Leave a Reply

Your email address will not be published. Required fields are marked *