the database was restored and upgraded to 2008 compatibility level. Indexes were rebuilt so my understanding is that the statistics are updated as well.

ran update statistics with fullscan on the underlying base tables. Let me get the plans.

ok...just an update on this. The sql 2000 server had 8 processors where the 2008 server had only 2. We bumped that up to 4 and had much...

the sproc is doing a select against 4 views which are comprised of several different base tables. These views exist in both environments and are not indexed in either...

it shows that I have 9.00.1399.00

I'm working on getting this information. Thanks

thanks for both replies. I have checked configuration settings and they are the same. I have updated statistics, checked that all tables have the same indexes, and looked...