According to documentation, whenever we write to a delta table, statistics are auto computed.
Question is – we also have the analyze table command which we can execute to manually compute statistics.
Question is – is there any use case where we need to explicitly compute statistics using analyze table, especially when any write to the delta table ends up computing statistics.
I am referring to tables well within the default limit of 32 columns for which statistics is collected by default.
Info on auto collection of stats for every write here
analyze table here
In some relation dbs, stats is by default computed only on certain conditions, but delta doc says stats is updated on every write , and that is why this question.