Re: snapshot vs MV

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 8 Mar 2004 12:39:03 GMT
Message-ID: <404C6967.7DD6FC0A@remove_spam.peasland.com>

zeb wrote:
>
> Hi,
>
> Is there any differences between snapshot and materialized views
> or is it exactly the same thing with a new name ??
>
> Thanks for your lights...

They aren't *exactly* the same thing, but close. As others have said, the new name for Snapshots is MVs. Snapshots have been retained for backwards compatibility. However, MVs have more features than the older Snapshots. For instance, with MVs, you have the Query Rewrite ability. Snapshots don't get to enjoy this features.

HTH,Brian Received on Mon Mar 08 2004 - 06:39:03 CST