Does Azure SQL DB support automatic indexed views?
First published on MSDN on Sep 04, 2016 Are indexed views used automatically in SQL Azure without "WITH (NOEXPAND)"?How does it work?and How the query optimizer decides to use it or not ?The query optimizer uses indexed views to speed up the query execution.