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.
Yes, SQL Server can update indexed views incrementally, but there are severe limitations:
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.