Arcadia Engine automatically starts routing queries to the analytical view, if a match is found.
Consider the queries QP, QD, and QPD.
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 |