Re: Tuning Experts

Hi Amit,

Nice that you have posted query and execution plan. Some points I would like to say are

1) If possible can we remove Left JOINs??
2) You are using IN to compare single value. Try to use = there.
3) replace Or conditions by using 'Union ALL' .

I hope these helps.

With Warm regards
Jatinder Singh Received on Fri Sep 29 2006 - 04:20:21 CDT