I am looking for way to add hints for joins.
Our app uses EF, I have found one query which executes 1 minute.
It is EF generated query used multiple joins with subqueries. After I have added HASH JOIN the query works 1 second in SSMS.
How to add HASH hint to JOIN used into the generated query?