Hi,
I need to optimize a query that retrieves data by joining 4 tables, where 2nd table has 1 million records. i need to optimize the query to retrieve the information faster. Kindly give me the solution for this problem.
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Manish Kumar ChoudharyPosted Dec 2, 2014, 11:20 PM
Hi Prabu Spark,
Go through following links it might help u.
http://www.codeproject.com/Articles/35665/Top-steps-to-optimize-data-access-in-SQL-Serv
http://technet.microsoft.com/en-us/magazine/2007.11.sqlquery.aspx
https://www.simple-talk.com/sql/sql-training/the-sql-server-query-optimizer/