Post reply

materialized view

  • March 28, 2006 at 5:46 am

    #90987

    Does SQL server 2000 support materialized views?

    Sam

  • March 28, 2006 at 6:31 am

    #629130

    Yes, it does.  It's called indexed views in SQL Server.  MVs are Oracle lingo.

    From BOL:

    Indexed views can be created in any edition of SQL Server 2000. In SQL Server 2000 Enterprise Edition, the query optimizer will automatically consider the indexed view. To use an indexed view in all other editions, the NOEXPAND hint must be used.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply