My advice:INDEXing a poor-performing query is like putting sugar on cat food. Yeah, it probably tastes better but are you sure you want to eat it?The path of least resistance can be a slippery slope. Take care that fixing your fixes of fixes doesn't snowball and end up costing you more than fixing the root cause would have in the first place.

Adelphi (9/13/2013)I would be grateful if you could help me with query

Thanks

I find it interesting that you have waited more than a year to say anything. I am glad to see that Dwain has provided you with a possible solution, but I have to wonder what you have done during this past year and why you didn't come back sooner asking for help.

So I would be interested in knowing what you had tried during this long absence from your question. What problems did you encounter and what do you still not understand. We aren't here to do your work for you, we are here to help you learn and improve your knowledge and skills. You have to remember that what ever code you get from us, or anywhere else on the internet, you have to own. If you don't understand it you should not use it in production. You are the one who has to support it.

And as Dwain indicated, I am currently in Afghanistan, but I still can help when I have the time.