Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Delete is very slow
if you want to delete all rows from a table it is better to use
truncate table my_table.
it must be faster.
Loy&Hutz wrote in message <01be13aa$451625c0$6d6464c3_at_kom>...
>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
>
>
Received on Thu Nov 19 1998 - 06:26:03 CST