Reflection Behavior on Views Built from Other Views

1

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!

2

A raw refection on table 1 would benefit both view1 and the UNION of both.