• 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.