How are stats collected on a Delta column utilized

[aladda · Accepted solution]

Stats collected on a Delta column are either using for Partitioning Pruning, Data Skipping. See here - https://docs.databricks.com/delta/optimizations/file-mgmt.html#delta-data-skipping for details

In additional stats are also used for Metadata only queries such as

select min(colA) from table