Greetings,
* Job (j...@colliniconsulting.it) wrote:
> >>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-table that you update
> >>regularly with appropriate SQL to issue UPDATE statements for just the
> >>current day
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-table that you update
>>regularly with appropriate SQL to issue UPDATE statements for just the
>>current day (or whatever).
If correct, i leave only last da
Greetings,
* Job (j...@colliniconsulting.it) wrote:
> we use a materialized view to aggregate datas from a very big table
> containing logs.
> The source table is partitioned, one table for a day.
>
> Since the refresh of the materialized view seems to grow a lot about timing,
> we would like t
Hello,
we use a materialized view to aggregate datas from a very big table containing
logs.
The source table is partitioned, one table for a day.
Since the refresh of the materialized view seems to grow a lot about timing, we
would like to know if it is pssible to make a "partitioned materializ
