Christian Buettner (9/1/2008)
Hm, I am not sure whether I am correct, but from the QOTD, it is not clear whether the several steps involve the same tables or different tables. So DROPCLEANBUFFERS might still be an option.
Hi Christian,
If it's known that the different steps (a) involve different tables, and (b) do not involve that might end up refering to the same tables either, then DROPCLEANBUFFERS is indeed more useful.
If I had known that Hugo is the author of the QOTD, I would have chosen the correct answer.
If this is the compliment it looks like, then I thank you for it.
(And if it isn't, then I'll just choose to misunderstand you and perceive it as a compliment anyway :D)