I have migrated a database from 2000 to 2005, updated the statistic and rebuild the index.
When I run the following query
"select top 500 * from myview order by name", it is extremely slower in 2005 than 2000. The myview simply does an inner join with 2 table. The name is varchar(50). Strangely when I remove the top 500, the time to run the query on 2000 and 2005 quite similar.
Does anyone have any idea why this is occurring, or any input, this is really puzzling me???