> I think SQL Server can do this, but...then you have to use SQL Server. Yes, SQL Server can update indexed views incrementally, but there are severe limitatio

> I think SQL Server can do this, but...then you have to use SQL Server. Yes, SQL Server can update indexed views incrementally, but there are severe limitations: https://learn.microsoft.com/en-us/sql/relational-databases/views/create-indexed-views?view=sql-server-ver16#additional-requirements https://learn.microsoft.com/en-us/sql/relational-databases/v... If memory servers, indexed views have been in SQL Server for 20-odd years, and haven't seen meaningful improvements in all that time. We still can't do a LEFT JOIN, or join the same table more than once or MAX etc... The same story with T-SQL, which is firmly stuck in the '80s (not that other databases are better). There are some extremely powerful features in SQL Server that can be used effectively with some pain, but they could be so much better if Microsoft invested in fully fleshing-out their potential instead of chasing the latest buzzword. Sorry for the rant.