Hi team,
I have two base tables: table1 and table2.
I created a view on table1 as:
SELECT * FROM table1 WHERE date > CURRENT_DATE - 7;
I also created a view on table2 as:
SELECT * FROM table2 WHERE date <= CURRENT_DATE - 7;
Then, I created a final view that combines both:
SELECT * FROM view1
UNION
SELECT * FROM view2;
Now, if I enable a reflection (row or aggregation) at the table level - on table 1, my question is:
Will the reflection apply only to view1 or will it also benefit the final view created using the UNION of both?
Thanks in advance for your help!