2 ms·
You've been able to do joins in them for a decade. You just can't do self-joins. (But there are indeed a ton of restrictions.)
by BrentOzar 7y ago
You've been able to do joins in them for a decade. You just can't do self-joins. (But there are indeed a ton of restrictions.)
- hotsauceror 7y agoAccording to this here web site, it also forbids outer joins, which is probably what I was remembering. https://docs.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver15 https://docs.microsoft.com/en-us/sql/relational-databases/vi...
- Pxtl 7y agoThey're basically only usable on a super blue moon lunar eclipse.