4 ms·

"What I have yet to see but always secretly wanted, however, is a database that natively supports incremental updates to materialized views" SQL Server ala 10+

• biggestlou 6y ago
  That's good to know! SQL Server has really never been on my radar but I think it's a good time to do some exploration.
• liprais 6y ago
  Teradata does that too
• jiggawatts 6y ago
  I've actually used materialized views in production on SQL Server, and they're great when they work, but they have far too many limitations. Most of these make sense, but some of the join limitations are internal constraints of the engine, not a fundamental limit. This prevents their use for a wide range of scenarios where they would be useful...
• garyclarke27 6y ago
  When I tried to use auto incremental materialized views in SQL Server (about 10 years ago) - they had so many limitations that they were virtually useless. I now use Postgres and this is the Number 1 feature that’s missing for me, there have been a few attempts that have unfortunately not made it into the core. I don’t understand why this critical capability is not even on the radar of the core developers - maybe this publicity from Materialize will raise its priority.