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???
Free Guide: Managing storage for virtual environments
Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!