question

DavidD avatar image
DavidD asked

indexed views and licensing

hi all, i recently did some testing of indexed views to help performance of some of my queries, and looking at the execution plan i cant seem to get the plan to use the index. i went [here][1] and it seems that indexed views are only available in enterprise edtion? can someone confirm that im reading this correctly? all the sites ive read about these types of indexes, noone has mentioned that you require ent edition to use them so i thought maybe im reading it incorrectly. also strange that it lets you create the index (and kill your update/inserts) and not let you use them... [1]: http://www.microsoft.com/sqlserver/2008/en/us/editions-compare.aspx
sql-server-2008indexeseditions
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
TimothyAWiseman avatar image
TimothyAWiseman answered
No, you can use indexed views in standard edition, but you must explicitly invoke them using the NoExpand query hint if you are not using enterprise edition. I previously wrote about this at: [ http://www.sqlservercentral.com/articles/Indexed+Views/63963/][1] [1]: http://www.sqlservercentral.com/articles/Indexed+Views/63963/
4 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

DavidD avatar image DavidD commented ·
love your work
0 Likes 0 ·
TimothyAWiseman avatar image TimothyAWiseman commented ·
Thanks. I dealt with this exact situation a lot in a previous job.
0 Likes 0 ·
DavidD avatar image DavidD commented ·
im also curious as to why microsoft listed it in the edition comparison as not being available in standard or express though... but i am glad it is at least available in std!
0 Likes 0 ·
Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
@Timothy - +1 - that article has actually helped me out twice! :)
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.