How many columns does Delta Engine collect stats on for a Delta Table

aladda
Databricks Employee
Databricks Employee
 

aladda
Databricks Employee
Databricks Employee

by default a delta table has stats collected on the first 32 columns. This setting can be configured using the following.

set spark.databricks.delta.properties.defaults.dataSkippingNumIndexedCols = 3

However there's a time trade-off to having a large number of columns set for stats collection. You typically want to collect stats on column that are used in filter, where clauses joins and on which you tend to performance aggregations.

View solution in original post