We did look at that but looks like CQN isnt supported on queries that involve DB links and MViews. Let me find out where i read that. On Wed, May 23, 2012 at 9:57 AM, Ilmar Kerm <ilmar.kerm@xxxxxxxxx> wrote: > On Wed, May 23, 2012 at 4:48 PM, rjamya <rjamya@xxxxxxxxx> wrote: > > Thanks Chris, > > Those (if we implement logs) again will be on the remote side, trying to > > see of anything can be checked locally. Any remote operation adds time > ... > > Maybe its possible to implement CQN on materialized view? > http://docs.oracle.com/cd/B28359_01/appdev.111/b28424/adfns_cqn.htm > > -- > Ilmar Kerm > -- > //www.freelists.org/webpage/oracle-l > > > -- //www.freelists.org/webpage/oracle-l