cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
cancel
Showing results for 
Search instead for 
Did you mean: 

should I run ANALYZE TABLE on Delta tables?

jose_gonzalez
Moderator
Moderator

I would like to know if it recommended to run Analyze table on Delta tables or not. If not, why?

1 ACCEPTED SOLUTION

Accepted Solutions

jose_gonzalez
Moderator
Moderator

You can run  ANALYZE TABLE  on Delta tables only on Databricks Runtime 8.3 and above.

For more details please refer to the docs: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-analyze-table....

View solution in original post

1 REPLY 1

jose_gonzalez
Moderator
Moderator

You can run  ANALYZE TABLE  on Delta tables only on Databricks Runtime 8.3 and above.

For more details please refer to the docs: https://docs.databricks.com/spark/latest/spark-sql/language-manual/sql-ref-syntax-aux-analyze-table....

Welcome to Databricks Community: Lets learn, network and celebrate together

Join our fast-growing data practitioner and expert community of 80K+ members, ready to discover, help and collaborate together while making meaningful connections. 

Click here to register and join today! 

Engage in exciting technical discussions, join a group with your peers and meet our Featured Members.