Blogs

Faster Dashboards with Multi-Column Approximate Sorting

duckdb.org

With any columnar data format, using advanced multi-column sorting when loading data can improve performance on a wide variety of selective read queries. Space filling curve encodings like Morton (Z-Order) and Hilbert approximately sort multiple columns together. Sorting by rounded timestamps adds additional benefits when filtering on recent data.

Visit Site

Blogs duckdb.org