Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.tools -> Re: Update VS Delete/Update
This is assuming you can't truncate it.
Update will be faster.
Also the second pair of commands will most likely force you to rebuild the
indexes on this table.
Hth,
Sybrand Bakker, Oracle DBA
"Brandon Duncan" <bduncan_at_pietechnet.com> wrote in message
news:8inu72$s8n$1_at_bob.news.rcn.net...
> Does anyone know which is faster :
> "UPDATE tablex SET ....."
>
> or
>
> "DELTE FROM tablex"
> "INSERT INTO tablex"
>
> Thanks,
> Brandon
>
>
>
Received on Tue Jun 20 2000 - 00:00:00 CDT