Re: Newbie question re refreshing Materialized Views

> It would help to have the following:
>
> 1. Oracle version number to 4 decimal places

It's 9i

> 2. The DDL used to create the MV
> 3. An explain plan taken both before and after the change
> -- you do run regular StatsPacks don't you?
> 4. Any indication of what has changed: Something has.

I'm not sure you read my question correctly. I'm not after a fix for the performance drop-off: as I said, someone else is already dealing with that.

I am asking a "semantical" question about how MVs work. None of the rest of your questions are relevant to that.

-- 
Adam