What are the best practices for Adaptive query execution

brickster_2018
Databricks Employee
Databricks Employee

What are common configurations used and which workload will get benefit