One of the several elements of Exalytics' power comes from it holding pre-calculated (aggregated) data in the TimesTen for Exalytics In-Memory Database. Exalytics comes with a tool called the Summary Advisor (which Mark Rittman has written about previously here) [https://www.rittmanmead.com/blog/2012/03/oracle-exalytics-week-the-summary-advisor/] which suggests