Thanks for review.

Yes you are right, these ORs are main issue. Earlier we had few more ORs, and by removing them I managed to get some 40-45% performance gain (I split the script and used UNION).

Now I'm not finding any way to remove these remaining ORs or to rewrite the script. Thats why I have put up the issue here, and I'm sure you intelligent brains can definitely suggest something.

Regards.