MicrosoftThis just seems like a way of allowing devs to shoot themselves in both feet at the same time. Query hints are emergency measures, not something to help people think they don't have to optimise the awful EF-generated slop that they force SQL Server to process.
Having said that, it might be useful to alert a good DBA to any low hanging fruit that could do with picking.
MicrosoftThe Query Hint Recommendation Tool, whether used within SSMS or programmatically, simply identifies what hints would provide benefit. The hints still have to be applied to the code - ideally using Query Store Hints to provide short-term relief while the problematic query is re-written.
