![[The AI Show Episode 142]: ChatGPT’s New Image Generator, Studio Ghibli Craze and Backlash, Gemini 2.5, OpenAI Academy, 4o Updates, Vibe Marketing & xAI Acquires X](https://www.marketingaiinstitute.com/hubfs/ep%20142%20cover.png)
![What tool should I be using for mapping a function across the complex domain? [closed]](https://cdn.sstatic.net/Sites/softwareengineering/Img/apple-touch-icon@2.png?v=1ef7363febba)
.jpg?#)
![YouTube Announces New Creation Tools for Shorts [Video]](https://www.iclarified.com/images/news/96923/96923/96923-640.jpg)
![Apple Faces New Tariffs but Has Options to Soften the Blow [Kuo]](https://www.iclarified.com/images/news/96921/96921/96921-640.jpg)
EF+SQL Server-generated query: how to add query hints?
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?
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?
