Roy, the idea is to minimize the work CAS has to do at query time (CAS action time). If a VA bar chart is grouping by region and the underlying data is already grouped (partitioned) by region then CAS doesn't have to group it. So the CAS action comes back quicker. Similarly, if a VA line chart is plotting data by date and the underlying data is already ordered by date then CAS doesn't have to sort it. So again the CAS action comes back quicker.

So partition by the most common grouping variables and order by the most common order-by variables.