• Not possible. To start with, you have outer joins which aren't allowed in an indexed view

    This isn't an Azure limitation, the earthed SQL product has the same long list of indexed view limitations.

    Perhaps an alternative approach? Instead of trying to index the views, maybe post the queries that are slow, the specific queries which access the views, along with their execution plans, table definitions and index definitions and we can try and help you tune the queries.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass