Can anyone plz guide on query optimization.

Please let me know which database you are using for query optmization and where exactly you are facing the challenges. There are severaloptimization techniques, need to understand the issue and apply optimization techniques accordingly.

Rijwan Ansari5y ago

You can follow guidelines

https://www.toptal.com/sql-server/sql-database-tuning-for-developers

https://www.sqlshack.com/query-optimization-techniques-in-sql-server-tips-and-tricks/

Rajanikant Hawaldar5y ago

https://www.c-sharpcorner.com/article/creating-console-application-in-c-sharp/

https://www.c-sharpcorner.com/article/how-to-optimize-sql-queries/

https://www.c-sharpcorner.com/article/sql-server-performance-tuning-tips/

https://www.c-sharpcorner.com/UploadFile/f3068a/sql-server-query-optimization-day1-basics/

Sachin Singh5y ago

This is really a good article on query optimization

https://www.sqlshack.com/query-optimization-techniques-in-sql-server-tips-and-tricks/