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