Do I still need to use skew join hints if I have Adaptive Query Execution enabled?

[User16826992666]

From what I have read about AQE it seems to do a lot of what skew join hints did automatically. So should I still be using skew hints in my queries? Is there harm in using them?

[sajith_appukutt · Accepted solution]

With AQE Databricks  has the most up-to-date accurate statistics at the end of a query stage and can opt for a better physical strategy and or do optimizations that used to require hints,

In the case of skew join hints, is recommended to rely on AQE skew join handling rather than use hints, because AQE skew join is automatic and in general performs better than the hint counterpart.