http://gothub.r4focoma7gu2zdwwcjjad47ysxt634lg73sxmdbkdozanwqslho5ohyd.onion/MaterializeInc/materialize
CREATE MATERIALIZED VIEW tpch_q15 AS SELECT s_suppkey,
s_name,
s_address,
s_phone,
total_revenue FROM supplier,
revenue WHERE s_suppkey = supplier_no AND total_revenue = ( SELECT max (total_revenue) FROM revenue
) ORDER BY s_suppkey; -- Creating an index keeps results always up to date and in memory. -- In this example, the index will allow for fast point lookups of -- individual supply keys.