Skip to Content
avatar image
Former Member

Table or View

Hi Experts,

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jul 20, 2015 at 05:15 PM

    IQ does not support materialized views.  They are in the docs, but only apply to catalog tables.

    Personally, I would try the view approach first since that is the easiest.  If it performs to your satisfaction, there is no need to create a permanent table.  Which version of IQ are you on?  We made some significant improvements to VIEW and UNION ALL processing in IQ 16 SP10 that may help you out.


    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Mark Mumy

      Thanks Mark for your reply.

      I was thinking of creating a summary table and get the data loaded into this table from other existing tables.

      Do you see any performance impacts if 1 summary table is created/loaded from multiple other tables?