How are stats collected on a Delta column utilized

aladda — Thu, 24 Jun 2021 04:26:12 GMT

Re: How are stats collected on a Delta column utilized

aladda — Thu, 24 Jun 2021 04:28:13 GMT

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