Hi All, What are the different ways to tune query performance especially when accessing Databricks Delta Tables using reporting tools , example: Power BI 1) Partitions - ( Dynamic Partition Pruning) 2) Keeping cols 1 - 32 ( enable stats for data skipping) 3) Z Order columns -(frequently filtered and joined cols) 4) Optimize ( deal with small file issues) 5) Vacuum (cleanup files no longer needed) I wanted understand if there are any other options left to tune performance other than increasing the compute/using photon especially for reporting needs. Thanks, Mohan

this recently came out and is pretty comprehensive

thanks @Christopher Grant 🙏