Thursday, February 08, 2007

Indexed View in SQL2K

It seems the usage of Indexed View is limited...to data warehouse only?
Mostly I am dealing with OLTP...

I wanna use index to boost my system, but it seems indexed view will slow down the performance.

some readings:
http://www.databasejournal.com/features/mssql/article.php/2119721
http://www.sqlteam.com/item.asp?ItemID=1015

1 comment:

Anonymous said...

Interesting to know.