When relevant rows are scattered across many small files, running an OPTIMIZE command with ZORDER BY reorganizes the data layout in storage. It compacts small files and colocates related information in the same set of files, drastically improving data skipping and query read performance.