Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Explain plan...
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 Wed Sep 23 1998 - 06:44:56 CDT