What indexed view capabilities does Azure SQL Database have? Does Azure SQL Database support indexed views? Does it support automatic indexed view matching without NOEXPAND? Does the answer depend on the pricing tier?

I was unable to find definitive answers to these questions. The feature differences guide does not mention indexed views.

The indexed view documentation does not contain the word "Azure".
I was just searching for an answer to this and I found an MSDN blog entry from 2016 that suggests that Azure SQL does support indexed view matching and may (in at least some circumstances) use indexed views without NOEXPAND. From the linked article:


  YES,The code proves that the  Azure SQL supports automatic use of indexed views without specifying the NOEXPAND hint.


The blog entry also provides a code example that the author uses to support their assertion. I won't reproduce it here but check out the article at: https://blogs.msdn.microsoft.com/azuresqldbsupport/2016/09/04/does-azure-sql-db-support-automatic-indexed-views/