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?

brickster_2018
Databricks Employee
Databricks Employee
 

brickster_2018
Databricks Employee
Databricks Employee

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.

View solution in original post