Posted by AK on 09/06/05 17:21

instead of deleting tons of rows, you could SELECT INTO <new table> the
rows you intend to keep, drop the old table, and rename the new one.
Could be much faster

• Next in forum: Getting count with multiple fields
• Prev in forum: Re: JDBC deadlock on unrelated records
• Thread view: Re: Massive delete in DB

[Reply to this message]