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