I have ran a stored proc to check indexes, both seem to be fine..(i.e. Identical on both systems) - hardware the same. Indexes have been rebuilt - and are unfragmented, its a relatively new DB. The fast machine has more data than the slow one. And the lazy good fer nuthin' DBA hanging around would be me. A junior dev - thanks for the support.


The text based execution for the slow query is here.

http://docs.google.com/Doc?id=dgvz75z2_0d4gcs5dk