Skip to content
Lakehouse Compare

Glossary, read 10 Nov 2026

Z-ordering

All termsOpen the Compute Bill

It is a multi-dimensional clustering: unlike a single-column sort, it keeps files useful for filters on any of the chosen columns, within limits.

Z-order has to be rerun as data arrives. Databricks now recommends liquid clustering instead, and says clustering cannot be combined with ZORDER.

A sourced example

The Delta Lake optimizations page gives the command OPTIMIZE events ZORDER BY (eventType) and notes that statistics on long string or binary columns are costly to collect.

Sources

  1. Delta Lake documentation: optimizations, read 10 Nov 2026

Last reviewed 10 Nov 2026.