How to index cube style queries with changing aggrigations
I am an Oracle developer. Relating to how CI is implemented in Oracle, here are a few pitfalls to avoid.


Ensure that the table tbl is small enough to avoid overflow segments.
The table tbl must be ideally used only for bulk Inserts and Selects. Updates, Deletes and interspersed Inserts will cause page split.
If there are other non clustered indexes on tbl, ensure that those indexes do not end up with huge ClusteringFactor post converting tbl to CI.
Sharding tbl might help provided it does not affect other indexes and SQL performance.