>Thanks for that, but doing a "delete from mytable" is very slow, and I was
>after a faster way, but maybe there isn't one.

Wonder why it is slow. Do you have any before or after delete triggers? Or
indexes that aren't uniquely qualifying each row (I think deletes will be
slower if you have indexes with many duplicates - if so, add the pk at the
end of the index)?

Set