https://community.databricks.com/t5/data-engineering/do-i-still-need-to-use-skew-join-hints-if-i-have-adaptive-query/m-p/23471#M16199 <P>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?</P> Thu, 17 Jun 2021 03:59:37 GMT User16826992666 2021-06-17T03:59:37Z https://community.databricks.com/t5/data-engineering/do-i-still-need-to-use-skew-join-hints-if-i-have-adaptive-query/m-p/23471#M16199 <P>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?</P> Thu, 17 Jun 2021 03:59:37 GMT https://community.databricks.com/t5/data-engineering/do-i-still-need-to-use-skew-join-hints-if-i-have-adaptive-query/m-p/23471#M16199 User16826992666 2021-06-17T03:59:37Z https://community.databricks.com/t5/data-engineering/do-i-still-need-to-use-skew-join-hints-if-i-have-adaptive-query/m-p/23472#M16200 <P>With AQE Databricks &nbsp;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,</P><P></P><P>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.</P><P></P><P></P> Fri, 18 Jun 2021 06:13:31 GMT https://community.databricks.com/t5/data-engineering/do-i-still-need-to-use-skew-join-hints-if-i-have-adaptive-query/m-p/23472#M16200 sajith_appukutt 2021-06-18T06:13:31Z