Deleting Large number of Rows

How can I quickly delete large numbers of rows?

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
pstryjew_at_worldnet.att.net Received on Thu Feb 18 1999 - 12:04:52 CST