Yep, they are indexed. and statistics also updated. The DBA already did all that.. Any more idea?

Hi everyone, I am also encountering the same problem with Steve here.

It took 2 mins+ to execute the query on the prod. server while in dev. (a notebook) and other...