An Awesome Simple Tip for Indexed Views in SQL Server Standard Edition - Hands On Easy Demo!
Index Views in SQL Server Standard Edition have a few limitations compared to Enterprise Edition, but none the less are still a very powerful technology that all SQL professionals involved with reporting systems should consider using for high performance aggregate reporting.
( / greg-c-coopman-b07b54103 )
Note: Although I have not verified this completely, in SQL Server Standard Edition 2016 SP1 the indexed view may work the same as Enterprise Edition (meaning you can run queries against the base table name, without NOEXPAND (or naming the index view), and the optimizer will pick up and use the Indexed View automatically.) Please let me if you also have experienced this or can verify this. If this is true, you can watch the video, "Indexed Views in SQL Server Enterprise Edition, • Super Power Your Query with Indexed Views ... .