Z ordering best practices

User16826994223
Databricks Employee
Databricks Employee

What are the best practices around Z ordering, Should be include as Manu column as Possible in Z order or lesser the better and why?

sajith_appukutt
Databricks Employee
Databricks Employee

With Z-order and Hilbert curves, the effectiveness of clustering decreases with each column added - so you'd want to zorder only the columns that you's actually use so that it's speed up your workloads.