On 9/19/07, Simon Riggs <[EMAIL PROTECTED]> wrote:
> In your last post you mentioned multiple UPDATEs. Pruning multiple times
> for successive UPDATEs isn't going to release more space, so why do it?
I guess the point is when you do the first update, there is enough free
in the page and hence we won't prune the page. We run out of free space for
subsequent updates and want to prune, but now can't prune because executor
is holding a pin on the buffer.