Hi Stephen.
>>The mat view takes longer and longer to update because it runs the full query. What you really want to do is have a
side-tablethat you update regularly with appropriate SQL to issue UPDATE statements for just the current day (or
whatever).
If correct, i leave only last datas into "side-table" and syncronize only these datas in the materialized view.
If i delete datas from the side-table (ex- truncate) during the next materialized view update they will be lost or
remainintact?
Thank you
Francesco