ArcEngine Cost Model

Arcadia Enterprise performs a 'what-if' analysis to determine which combination of analytical views leads to best possible performance.

The Cost Model routes incoming queries based on the best possible match from all available analytical views, by evaluating each candidate to determine which one requires the least number of rows fetched. It always minimizes the number of rows because the I/O cost is a very significant factor in query performance. Where appropriate, it uses a combination of two or more analytical views.

As part of this strategy, the cost model uses partition filtering. If a query uses a predicate on a partition key, the cost model chooses an analytical view that matches the partitioning over an analytical view that does not, because the first option allows ArcEngine to read a smaller subset of rows.