https://community.databricks.com/t5/data-engineering/what-s-the-recommended-number-of-columns-you-z-order-a-delta/m-p/20927#M14175 Thu, 24 Jun 2021 04:11:10 GMT aladda 2021-06-24T04:11:10Z https://community.databricks.com/t5/data-engineering/what-s-the-recommended-number-of-columns-you-z-order-a-delta/m-p/20927#M14175 Thu, 24 Jun 2021 04:11:10 GMT https://community.databricks.com/t5/data-engineering/what-s-the-recommended-number-of-columns-you-z-order-a-delta/m-p/20927#M14175 aladda 2021-06-24T04:11:10Z https://community.databricks.com/t5/data-engineering/what-s-the-recommended-number-of-columns-you-z-order-a-delta/m-p/20928#M14176 <P>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. </P> Thu, 24 Jun 2021 04:12:46 GMT https://community.databricks.com/t5/data-engineering/what-s-the-recommended-number-of-columns-you-z-order-a-delta/m-p/20928#M14176 aladda 2021-06-24T04:12:46Z