arch_db
New Contributor III

Photon enable dynamic file pruning.

About DFP speedup you can watch in https://www.youtube.com/watch?v=yZmrpXJg-G8

This session explores optimizing MERGE performance using Liquid Clustering and Photon. It explores how you can use recent Delta Lake and Photon features such as Liquid Clustering, Deletion Vectors, and Predictive I/O for Updates to make your MERGEs run smoothly and with predictable performance ...