query plans different

I have two 4 way server( production and test)
The only difference being IO layout and production has more RAM than the
test box
Same database on both ( did a backup and restore so as to be identical in
schema,etc)
but the query plans are different. it runs in like 1 sec in test and over a
min in production.
How do i go about getting the same query plan from test over to production ?Hassan,
Check to make sure the statistics are current and up-to-date. Out-of-date
statistics can cause the optimizer to choose a different access method.
HTH
Jerry
"Hassan" <hassanboy@.hotmail.com> wrote in message
news:OjHNVyA1FHA.3892@.TK2MSFTNGP12.phx.gbl...
>I have two 4 way server( production and test)
> The only difference being IO layout and production has more RAM than the
> test box
> Same database on both ( did a backup and restore so as to be identical in
> schema,etc)
> but the query plans are different. it runs in like 1 sec in test and over
> a min in production.
> How do i go about getting the same query plan from test over to production
> ?
>