Very Computer

Currently, I have a list of "index" values (that are a retreival key).

I "pipe" these commands into a sqlplus session.

delete from <table> where <index> = value;

after 5000 deletes, I put in a commit;

These aren't really grouped together, so each one is a separate delete
statement.

Pete Stryjewski

If you get smarter, you can divide the deletes up and batch off several
processes deleting rows concurrently.

If you are deleting a lot of the table, you could drop the indexes, do
the delete (driving of the delete table), then rebuild the inndexes. As
you will find deleting the index values will take much longer than
deleting the rows.

Another alternative is to copy the rows you are NOT deleting to a new
table, then drop the original table and rename the temp table.

Andrew.

Hi,

    If you are trying to get rid of all the rows, use truncate.

    Another way to do batches is:

    delete from <table> where rownum <= 5000;
    commit;

    Use that in place of each group.

Mike Stout