databasejournal.com databasejournal.com

Indexed Views Basics in SQL Server 2000 - Page 3

Restrictions on Columns in the View The columns that can be in the SELECT list or WHERE clause of an indexed view are restricted. There are two possibilities based on the query: GROUP BY or no GROUP BY. If there is no group by, the columns may not contain expressions. However, they can contain computed fields in base tables and user-defined functions. On the other hand, if there is a GROUP BY clause, the following restrictions...