Re: Newbie question re refreshing Materialized Views

> Truncate works like that because it also releases all of the used
> storage except for the initial extent, hence it's DDL. There are
> other options to truncate which can alter this behaviour somewhat, but
> in general one uses truncate to do just that, clear out a table and
> reclaim most of the space it once used.

Makes perfect sense: I didn't think about the storage side of things. I just assumed that was all done by magic.

Thanks.

-- 
Adam