Re: materialized view

From: <mike7411_at_gmail.com>
Date: 30 Jul 2006 12:50:20 -0700
Message-ID: <1154289020.722539.277110@h48g2000cwc.googlegroups.com>

I just want to know if the view has what is currently in the table.

The count could easily be the same even if the data isn't current.

Ranko.Mosic_at_gmail.com wrote:
> select count(*) from table on both nodes; if same they are in sync,
> Frank van Bortel wrote:
> > mike7411_at_gmail.com schreef:
> > > Is there an easy way to tell if a materialized view is in sync?
> > >
> > > Thank you.
> > >
> > Define in sync...
> > Until then: Probably not.
> >
> > --
> > Regards,
> > Frank van Bortel
> >
> > Top-posting is one way to shut me up...
Received on Sun Jul 30 2006 - 14:50:20 CDT