Thanks for all your ideas and Suggestions.

Hi Dixie,

In the production the query is running on a view which has again joined using many other views. It has 4 views and...