Neoview SQL Reference Manual (R2.4 SP2)

FROM sales, store
WHERE sales.storekey = store.storekey;
• This is an example of an MAJV:
CREATE MATERIALIZED VIEW sales_by_day_category
REFRESH ON REQUEST
INITIALIZE ON REFRESH
AS SELECT part.category, time.day, SUM(price) sum_price
FROM sales, part, time
WHERE sales.timekey = time.timekey
AND sales.partkey = part.partkey
GROUP BY part.category, time.day;
68 SQL Statements