Details
-
Improvement
-
Status: Open
-
Minor
-
Resolution: Unresolved
-
None
-
None
-
None
Description
A recent interesting work(Wide Table Layout Optimization based on Column Ordering and Duplication) has indicated that in column store with massive number of columns, the ordering of columns may significantly affect the query performance.
Maybe we can record some statistics of the query orders when a FileNode is being queried, so that in future flushs we can adjust the order of the column based on the statistics.
For the full paper, please see: