Steps to optimize a query that retrieves data by join 4 tabl

Question

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.

Manish Kumar Choudhary · Answer

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/