>> Hi, >> >> Attached is the latest patch (v15) to add support for Incremental Materialized >> View Maintenance (IVM). It is possible to apply to current latest master branch.
I have tried to use IVM against TPC-DS (http://www.tpc.org/tpcds/) queries. TPC-DS models decision support systems and those queries are modestly complex. So I thought applying IVM to those queries could show how IVM covers real world queries.
+1, This is a smart idea. How did you test it? AFAIK, we can test it with:
1. For any query like SELECT xxx, we create view like CREATE MATERIAL VIEW
mv_name as SELECT xxx; to test if the features in the query are supported.
2. Update the data and then compare the result with SELECT XXX with SELECT
* from mv_name to test if the data is correctly sync.