Thank you all. I appreciate every one on this thread. USING NO INDEX resolved this problem. thank you all.