I am having a query where I am connecting to eight different tables using joins. When I join one table to another the speed of the execution becomes less. Even on my local server it is taking nearly 2 to 3 minutes to execute the query. How can I increase the speed of execution of my query.
Thanks in advance,
UdayGo to Query Analyzer and run it with the 'Show Execution Plan'. That will give you an idea where the performance issue is. Index all the fields that are involved in the joins and in the WHERE clause.
No comments:
Post a Comment