Press "Enter" to skip to content

Fixing Aggregate Performance with Indexed Views

Erik Darling makes a proposal:

So, here’s where indexed views are tough: THERE ARE SO MANY RESTRICTIONS ON THEM IT’S ABSURD.

They are borderline unusable. Seriously, read through the list of “things you can’t do” I linked to up there, and note the utter scarcity of “possible workarounds”.

Aside from that, indexed views often are counter-productive, as Erik shows.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.