Re: Which is faster when deleting rows? In() or Separate Delete stmts?

2007-11-03 Thread Baron Schwartz
Hi mos wrote: If I have a large table with 20 million rows, is it going to be faster to use one delete statement like: delete from mytable where rcdid in(20,300,423, 9) to delete 10-100 random records using the primary index "RcdId" or should I use separate delete statements for eac

Which is faster when deleting rows? In() or Separate Delete stmts?

2007-11-03 Thread mos
If I have a large table with 20 million rows, is it going to be faster to use one delete statement like: delete from mytable where rcdid in(20,300,423, 9) to delete 10-100 random records using the primary index "RcdId" or should I use separate delete statements for each RcdId as in: