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 ?