3 ms·
Actually the last time I checked, materialized views had a ton of restrictions on them, including things like not being able to use joins. Has that changed in
by hotsauceror 7y ago
Actually the last time I checked, materialized views had a ton of restrictions on them, including things like not being able to use joins. Has that changed in recent versions?
- BrentOzar 7y agoYou'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.