Re: Explain plan...

There isn't any trigger,any constraint on ad_check_saldo... Peter

plomax_at_oriolecorp.com wrote:

> If you look closely at your trace you have forgotten a constraint (contrarily to
> what you think) or the big hidden trigger?
> The best approach would be to rewrite the view.
> Regards
> Peter
>
> Peter Rak wrote:
>
> > Hi.
> >
> > I have two SQL statements:
> > 1.
> > select 1,gco_code,gan_code,sum(remain_amt)
> > from vad_otvp_pol_view
> > where gan_code='31101' and gco_code='076'
> > and gan_gcn_code='ZOS'
> > group by gco_code,gan_code;
> >
> > 2.
> > insert into ad_check_saldo (code,gco_code,gan_code,remain_amt)
> > select 1,gco_code,gan_code,sum(remain_amt)
> > from vad_otvp_pol_view
> > where gan_code='31101' and gco_code='076'
> > and gan_gcn_code='ZOS'
> > group by gco_code,gan_code;
> > .....
Received on Thu Sep 24 1998 - 01:57:35 CDT