topic After applying a MERGE in a previously Z-ORDERED table, Will the table loses the entire Z-ORDER optimization or only on the files touched by the MERGE? in Machine Learning https://community.databricks.com/t5/machine-learning/after-applying-a-merge-in-a-previously-z-ordered-table-will-the/m-p/20464#M1121 Thu, 24 Jun 2021 18:02:59 GMT brickster_2018 2021-06-24T18:02:59Z After applying a MERGE in a previously Z-ORDERED table, Will the table loses the entire Z-ORDER optimization or only on the files touched by the MERGE? https://community.databricks.com/t5/machine-learning/after-applying-a-merge-in-a-previously-z-ordered-table-will-the/m-p/20464#M1121 Thu, 24 Jun 2021 18:02:59 GMT https://community.databricks.com/t5/machine-learning/after-applying-a-merge-in-a-previously-z-ordered-table-will-the/m-p/20464#M1121 brickster_2018 2021-06-24T18:02:59Z Re: After applying a MERGE in a previously Z-ORDERED table, Will the table loses the entire Z-ORDER optimization or only on the files touched by the MERGE? https://community.databricks.com/t5/machine-learning/after-applying-a-merge-in-a-previously-z-ordered-table-will-the/m-p/20465#M1122 <P>The impact will be only on the files touched by the MERGE operation. The newly created files will not be optimized and data co-locality is not ensured. However, the files which are not touched by the MERGE operation will continue to show the improvements/benefits of Z-ORDER. </P> Thu, 24 Jun 2021 18:04:13 GMT https://community.databricks.com/t5/machine-learning/after-applying-a-merge-in-a-previously-z-ordered-table-will-the/m-p/20465#M1122 brickster_2018 2021-06-24T18:04:13Z