Enable Z-order indexing globally by setting spark.conf.set("spark.databricks.delta.autoZorder.enabled", True).

Use spark.conf.set("spark.databricks.delta.autoCompact.zorder.enabled", True) to globally enable Z-order indexing with Auto Compaction.

Z-order indexing with Auto Compaction must be enabled individually per table using:

ALTER TABLE table_name SET TBLPROPERTIES (delta.autoOptimize.zorder.enabled = true).

No additional configurations are needed; Z-Ordering is automatically enabled with Auto Compaction.

Z-order indexing cannot be enabled with Auto Compaction as it does not support Z-Ordering.