Processing User Queries

Arcadia Engine automatically starts routing queries to the analytical view, if a match is found.

Consider the queries QP, QD, and QPD.

Comparing Three Queries
QP QD QPD
This query is issued by a bar chart that shows totals of events, by platform. This query is issued by a line chart that shows totals of events, by day. This query is issued by a line chart that shows totals of events, by platform by day.
select count(*),  platform
  from events
  group by platform
select count(*), day
  from events
  group by day
select count(*), platform, day
  from events
  group by platform, day

QP matches QA.

It is processed using the analytical view.

QD does not match QA.

It is processed using the base table.

QPD does not match QA.

It is processed using the base table.

Note that while platform is in QA, day is not.