Re: Update VS Delete/Update
From: Yogesh Sharma <sharmayNOSPAM_at_usa.net.NOSPAM>
Date: 2000/06/20
Message-ID: <394F819E.42C2989F_at_usa.net.NOSPAM>#1/1
Date: 2000/06/20
Message-ID: <394F819E.42C2989F_at_usa.net.NOSPAM>#1/1
If you are deleting all row that use
truncate table
and for loading use hints for faster load.
Brandon Duncan wrote:
> 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 CEST