https://community.databricks.com/t5/data-engineering/z-ordering-best-practices/m-p/23243#M16008 <P><B>With Z-order</B>&nbsp;and&nbsp;<B>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. </B></P> Thu, 17 Jun 2021 17:01:41 GMT sajith_appukutt 2021-06-17T17:01:41Z https://community.databricks.com/t5/data-engineering/z-ordering-best-practices/m-p/23242#M16007 <P>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?</P> Thu, 17 Jun 2021 14:59:52 GMT https://community.databricks.com/t5/data-engineering/z-ordering-best-practices/m-p/23242#M16007 User16826994223 2021-06-17T14:59:52Z https://community.databricks.com/t5/data-engineering/z-ordering-best-practices/m-p/23243#M16008 <P><B>With Z-order</B>&nbsp;and&nbsp;<B>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. </B></P> Thu, 17 Jun 2021 17:01:41 GMT https://community.databricks.com/t5/data-engineering/z-ordering-best-practices/m-p/23243#M16008 sajith_appukutt 2021-06-17T17:01:41Z