Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Delete rows is slow
While more memory would help, you can speed this up by using the TRUNCATE
command:
truncate table Tab1 ;
This effectively removes all rows from the table very quickly but, bear in mind, it is not reversible - once executed, the data is gone..... It is also only used for full deletes ( no where clauses allowed )...
"Loy&Hutz" <loyhutz_at_dinx.de> wrote:
>Hello everybody !
>
>I am new in Oracle world and have this problem:
>
>My test server (NT4.0 Server - Oracle 8.0.4-Server with Pentium 200 and
>only 64 MB RAM) needs very long for deleting rows.
>
>e.g.: Delete * from Tab1 (30000 rows, 200 Cols) needs arround 15 minutes.
>
>all that time the server has disk access.
>
>is it a ram problem ? is the server always swapping pages ? Task manager
>says 90MB RAM in use.
>
>Thanks
>
>Sven
>
To reply please remove the 'nospam' part of the address Received on Thu Nov 19 1998 - 11:22:05 CST