Assuming I want to optimize for the query “select ...
# pinot-perf-tuning
k
Assuming I want to optimize for the query “select dim1,dim2,sum(met1) from t where dim3=‘val’ group by dim1,dim2 order by sum(met1) desc”, then (a) what’s the best ordering of fields in dimensionsSplitOrder, (b) does it matter whether met1 has a dictionary and/or an inverted index (I assume not), and (c) how would one tune the maxLeafRecords setting (or does that rarely matter)?