| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Speeding up deletes
Arthur Langham wrote:
>
> Sorry, forgot to mention:
>
> delete from table_name where table_field = some_criteria;
>
> Arthur Langham wrote in message ...
> >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?
> >
> >
Ouch!!!! In that case.... forget my suggestion (TRUNCATE)... Sorry!!!
Received on Tue Oct 13 1998 - 11:44:47 CDT
 |
 |