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

Home -> Community -> Usenet -> c.d.o.server -> Re: Speeding up deletes

Re: Speeding up deletes

From: Tim Jones <tojones_at_gate.net>
Date: Tue, 13 Oct 1998 10:45:36 -0400
Message-ID: <36236790.759B@gate.net> 





Arthur Langham wrote:


> 


> I need to speed up deletes. I'm looking into not logging the transaction (I


> don't care if I can rollback), though I don't know if this is possible. Any


> suggestions?




Use the TRUNCATE command option.



Example:   truncate <table_name>;
Received on Tue Oct 13 1998 - 09:45:36 CDT












Original text of this message













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