What indexed view capabilities does Azure SQL Database have?
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/