VIEWs in 2000 vs 2005

[DrSql]

We are in process of testing few db's to upgrade 2005.
WSome of our reports are running against few views. When we ran the select statement towads the view in 2000 we get a response back in 6 sec same sql run against 2005 came back in 6 mins. We also tried the same select statment against tables in 2005 and we got the results back in 5 sec.
So is there any know issues on 2005 views?
Is anyone came acorss smilar issues?
Thanks

Dr.Sql
Good Luck.

 

[mrdenny]

Indexes may need to be rebuilt. Stats may need to be updated, etc.

How did you migrate the database from SQL 2000 to SQL 2005.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[DrSql]

All indexes where rebulit and updated the STATS. I took a back of 2000 and restored in 2005.
Thanks

Dr.Sql
Good Luck.

 

[mrdenny]

What does the execution plan show?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com