Re: does refreshing materialized view make the database bloat?

["David G. Johnston" <david.g.johnston@xxxxxxxxx>]

On Sunday, January 15, 2023, jian he <jian.universality@xxxxxxxxx> wrote:

Hi,

why the materialized view itself bloats. If no refresh then no bloat right? If fresh then set based delete operation will make materialized view bloat?

I also found the same question online. https://dba.stackexchange.com/questions/219079/bloat-on-materialized-views Unfortunately nobody answered...

The definition of bloat is a deleted row.  Bloat can be reduced by subsequent row insertions.

David J.