cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Z-order or Hilbert Curve, which is better

brickster_2018
Databricks Employee
Databricks Employee

For Optimize on Delta table, there is support for 2 spatial curve algorithms. Which is better. Which one to choose for my workload.

1 REPLY 1

amr
Databricks Employee
Databricks Employee

The OPTIMIZE ZORDER operation now uses Hilbert space-filling curves by default. This approach provides better clustering characteristics than Z-order in higher dimensions. For Delta tables using OPTIMIZE ZORDER with many columns, Hilbert curves can speed up read queries by skipping more data than Z-order. For details, see Z-Ordering (multi-dimensional clustering).