What's the recommended number of columns you Z-order a Delta table by

aladda
Databricks Employee
Databricks Employee
 

aladda
Databricks Employee
Databricks Employee

Z-ordering is generally effective on up to 3-4 columns and New clustering algorithm in DBR 7.6 can even go upto 5 columns. However, the key is to Z-order on columns that are typically used in filters/where predicates and joins.

View solution in original post