Home Forums SQL Server 7,2000 Performance Tuning Indexing a view in SQL2000 RE: Indexing a view in SQL2000
Steve Jones - SSC Editor
SSC Guru
Points: 734498
More actions
January 9, 2015 at 10:16 am
#1769147
Read this first: http://technet.microsoft.com/en-us/library/aa902643%28v=sql.80%29.aspx
There are restrictions for your base tables. Essentially you build the view WITH SCHEMABINDING and add an index. An example about 2/3 of the way down the paper.