Re: Delete operation is very slow

From: Kevin Brand <kevin.brandx_at_tel.gte.com>
Date: Mon, 26 Oct 1998 16:34:54 -0600
Message-ID: <712tip$r7l$1@news.gte.com>

just remember that truncate will also wipe out your storage for both the table and indexes.

Probably getting progressively slower because your indexes were never getting 'cleaned' up. Each time you deleted all the rows, then re-inserted them, you were not re-using index storage. They are probably in need of a rebuild from scratch anyway.

-Kevin

remove the x for an email reply
krines_at_my-dejanews.com wrote in message <7118s6$eua$1_at_nnrp1.dejanews.com>...
>Hi,
>
>we have oracle version 7.3 and have a problem with the delete operation.
Every
>time we delete all records from the database, the time for this operation
>increases. The delete operation is very simple:
>
>delete * from label
>commit
>
>First we thought that the rollback segments are the problem but now we have
no
>more ideas.
>
>By the way, is there a easy way, to copy all records from one database to
an
>identical other database with a simple SQL statement? By now we copy every
>table with an "insert into" command from one database to the other.
>
>Thanks for your help...
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Oct 26 1998 - 16:34:54 CST