It would depend on how selective the filter clauses are and how scattered in the table the values of closed and cancelled time are.

What actions or suggestion do you provide here to resolve this issue?

How to Enable 10046 trace with level 8 ?

Can you please suugest how to create explain through toad?