Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: Update VS Delete/Update

Re: Update VS Delete/Update

From: Yogesh Sharma <sharmayNOSPAM_at_usa.net.NOSPAM>
Date: 2000/06/20
Message-ID: <394F819E.42C2989F@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 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US