Re: question on delete statement

"Fabio" <nonce_at_nulla.it> wrote in
news:EdzIa.104026$Ny5.3014229_at_twister2.libero.it:

> Hi
> I'm pretty new on Oracle so I'm sorry if this question was posted
> before.
>
> How is the behaviour of the DB engine on a complex delete query (I'm
> working on 9i)?
>
> If I had a query like
>
> delete (select * from A join B on A.f1=B.f1) C
> where C.f3 = '???' and C.f4 = 0
>
> which table (A or/and B) will be involved in the delete?
> How could I know if I'm deleting records from A table or B table or
> both ? Is there some syntax to specify the table I want delete records
> from?
>
> Thanks in advance
> Fabio
>
>
>

Have a look at the "explain plan" command in the sql manual. In sqlplus you can use the "set autotrace" command to have it explain the execution plan for you. Received on Fri Jun 20 2003 - 07:38:47 CDT