hi try this query. Kindly place the mandatory condition as the first statement in the where clause. And create the necessary index.
And most important thing is to replace the view. U have select...