I have a machine in our office Win Nt SP4 with Sql server 7.0.
Single Processor

Clients Site
Server with dual processors.

I have a Query that takes 7 minuts at my office but the same query takes 51 minutes at clients end.

Under the execution plan it shows the server using parallelism and at my office it doesn't use parallelism.

should i increase the time to the maximum for parallelism for this one stored procedure and then chnage it back to the default at the end of procedure...

or can any one help with making it run faster.

TIA
Shawn