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 ?