The latest articles on DEV Community by win32nipuh (@win32nipuh). https://dev.to/win32nipuh https://media2.dev.to/dynamic/image/width=90,height=90,fit=cover,gravity=auto,format=auto/https:%2F%2Fdev-to-uploads.s3.amazonaws.com%2Fuploads%2Fuser%2Fprofile_image%2F560486%2F63191dce-15f3-4834-a0e5-d15707f776d5.png https://dev.to/win32nipuh en win32nipuh Thu, 03 Apr 2025 15:35:46 +0000 https://dev.to/win32nipuh/efsql-server-generated-query-how-to-add-query-hints-5ag6 https://dev.to/win32nipuh/efsql-server-generated-query-how-to-add-query-hints-5ag6 <p>I am looking for way to add hints for joins.<br> Our app uses EF, I have found one query which executes 1 minute.<br> It is EF generated query used multiple joins with subqueries. After I have added HASH JOIN the query works 1 second in SSMS.<br> How to add HASH hint to JOIN used into the generated query?</p> entityframework