SQL Server keeps indexed views data synchronized with the underlying query by automatically updating the view indexes whenever there is any data modification in the base table. GeoPITS brings you the comprehensive details of Automatic indexed views maintenance's support in different versions & editions of SQL Server.
| Version | Enterprise | Standard | Web | Express (Adv.) | Express |
|---|---|---|---|---|---|
| Version v2019 | Yes | Yes | Yes | ||
| Version v2017 | Yes | Yes | Yes | ||
| Version v2016 | Yes | Yes | Yes | ||
| Version v2014 | |||||
| Version v2012 |
SQL Server keeps indexed views data synchronized with the underlying query by automatically updating the view indexes whenever there is any data modification in the base table
You can find more details about this version here
Back to all features