The filter on transaction_date only helps if the table is partitioned or liquid-clustered on that column — otherwise Delta reads all files. OPTIMIZE ... ZORDER BY (store_id) co-locates data for ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results