April 10, 2013 at 11:51 am
Hi,
I have a query which is using left outer join. Query should execute in seconds instead it is getting executed in mins.
Tried the possibilities:
1) Ran profiler to know the performance issue .
2)created appropriate index usage.. fragmentation checked(re-organized index)
3)checked estimated plan which shows clustered index(nested loop)-0.5% oly.
4) Cant optimize query in any means(re -structuring) .
Is there any ways to optimize the query ?
April 10, 2013 at 11:54 am
vishalsurya50 (4/10/2013)
Hi,I have a query which is using left outer join. Query should execute in seconds instead it is getting executed in mins.
Tried the possibilities:
1) Ran profiler to know the performance issue .
2)created appropriate index usage.. fragmentation checked(re-organized index)
3)checked estimated plan which shows clustered index(nested loop)-0.5% oly.
4) Cant optimize query in any means(re -structuring) .
Is there any ways to optimize the query ?
Based on what you posted? No.
Please post the DDL for the tables including the indexes, your code, and the actual (not estimated) execution plan as a .SQLPLAN file.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply