Performance Issue while updgrading from 6.5 to 2000greenspun.com : LUSENET : SQL Server Database Administration : One Thread |
We have a 10GB Database in SQL Server 6.5 and test upgraded to SQL Server 2000.The performance of views have become very slow compared to that of SQL Server 6.5. What tunning is need to make the views at least work like 6.5Thnaks in advance
-- Anonymous, March 19, 2002
Riyaz,I would try running DBCC DBREINDEX on the tables in question, then running sp_updatestats (which updates statistics on all your database tables).
If that does not improve performance look into "indexed views". This is documented in SQL Server Books Online.
Hope this helps,
Eric
-- Anonymous, March 19, 2002