Hi

Are your stats upto date on all the tables involved
How do you collect stats ?
is there a way to get back to the development team on this ?

Whats the acceptable time within which this query should finish ?