Materialized view

[laurence]

Hello !

I'd like to have your advice about materialized view.
I'll have to create aggregate table and i've told to look
at materialized view.

what kind of advice would you give me ?

Thanks for your help
Laurence

[tomate]

it is an interested thema and it is very good for fast querries from db.
It is not complicated but you must interested to in dimensions or star querries.

First we work so that we write our aggregated querries into views but this are very slow.

[sonaliak]

How are materialized views different from palin views ?
any eg.
thanks

[pipo]

a materialized view is a snapshot, that is to say that data IS stored in a table, while views are just stored as queries, and data is not available directly.
The other important point is that you have to manage a refresh for your snapshots, while you do not have to perform this on a view since data is just retrieved when the view is queried ...