Table or View
I want to create an aggregated or summary level at database level.
As my raw data is huge and my raw tables are partitioned into different tables to store such huge amount of data.
I want to create several summary table/view which can aggregate data at different levels.
What is the best option to do this -
1. Creation of permanent table ('select into' or 'create table')
2. Creation of simple view with 'union all' and group by.
3. Creation of Materialized view (never used this before so not sure of its impacts)
Also I want this table/view to be updated every so often. How can we achieve this?
Appreciate any help on this. Thanks a lot.