I think in all the dozens of times I've tried it I've never had a view pass their draconian requirements for indexing. There's always a self-join or a left joi

I think in all the dozens of times I've tried it I've never had a view pass their draconian requirements for indexing. There's always a self-join or a left join or a sqlclr function or a format or an unsupported aggregate or something else that was a critical thing that I really needed in the index. If the Microsoft SQL Server team really thinks this feature is a critical selling point, maybe they should work more on it since they were introduced back in like SQL Server 2005 and still have the same miserable whips-and-chains-bondage level masochism experience.