Indexed Views in SQL Server 2000

(Doug Carpenter) Views have been available throughout the history of Microsoft SQL Server. However, using views that return very large result sets can lead to poor performance, as the result set is not indexed and the entire result must be table scanned if the view is used in a join or a subquery of

Read More - Register for Free Membership