Is it going to make things faster if I: delete from s; reindex table s;
Why do you think this step would help you any? There's no index on p to begin with. You'd just be reindexing the auto-generated unique index on s (due to it being a PK).
delete from p;
And no, this would most likely be slower. Alban Hertroys -- If you can't see the forest for the trees, cut the trees and you'll see there is no forest. !DSPAM:737,48ae6140243481364815068!