There is a index on nevaldate, but i guess index is not being used because it has function in the where clause. this query takes 6 hours of time.
Do you think it works with using any hints.