tags:

views:

52

answers:

0

Many years ago (almost ten) I thought Index View is more like an enterprise edition (SQL 2000) only feature but I was wrong and Index view were indtroducted in SQL 2000 to satifsy competivive product's support for materialize view.

However, You can still create index view and physically materialize that view in all the edition of SQL 2000/2005 and query will use that index on a view if you specify NOEXPAND query hint (which is not needed in enterprise/developer editon)

Here is the white paper on Index View (that confirm what I said earlier) http://msdn.microsoft.com/en-us/library/dd171921.aspx

However, it appears to me that starting with SQL 2008/R2 index view indeed is an enterprise edition feature.

I did compare feature by different edition http://msdn.microsoft.com/en-us/library/cc645993.aspx

so in SQL 2008 R2 Standard edition you are able to create index view but looks like NOEXPAND hint will not work so it is almost useless...

Is it possible to create index view and use that index (instead of index on base table) in SQL Server 2008 R2 (standard or express edition) using noexpand hint?