In this blog they describe how you can create and use indexed views on express, web, standard, BI and enterprise editions. The difference is that for non-enterprise editions, you have to “force” the optimizer with a hint to use the index whereas enterprise editions will automatically consider the index and use it.
I remember having to use hints on Oracle to make sure it was using the right index in the past and it seems that nothing has really changed.
No comments:
Post a Comment
Note: only a member of this blog may post a comment.