Post reply

Indexed Views question for MSSQL2005

  • May 1, 2006 at 5:56 pm

    #68793

    OK. In SQL Server 2000 you could only index views in Enterprise and Developer editions. Is this still true for SQL Server 2005? I only have the Developer edition of 2005 or I would test it myself. I cant seem to find this info in the BOL anywhere.

    Thanks so much for your time!

  • May 1, 2006 at 6:00 pm

    #635234

    "Indexed view creation is supported in all editions."

    Source:

    http://www.microsoft.com/sql/prodinfo/features/compare-features.mspx

  • May 1, 2006 at 6:01 pm

    #635235

    Sorry, I should've been more clear. The whole quote is:

    "Indexed view creation is supported in all editions. Indexed view matching by the query processor is supported only in Enterprise Edition."

    So you can create it in whichever edition you want, but the query processor will only utilize it in Enterprise.

  • May 1, 2006 at 7:13 pm

    #635241

    Darn, still need Enterprise then. One of the best reasons to use Enterprise imo...

    Thank you!

  • May 4, 2006 at 1:00 am

    #635848

    If you want to use indexed views in non enterprise editions, you can use the hint NOEXPAND. The NOEXPAND view hint forces the query optimizer to treat the view like an ordinary table with a clustered index. It prevents view expansion.






    Regards,
    Sudheer 

    My Blog

  • May 5, 2006 at 6:33 pm

    #636390

    No, we are talking about creating an index on a view not using a view's indexes.

Viewing 6 posts - 1 through 5 (of 5 total)

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