Originally posted by marist89
So what's the point of truncating if you're going to fill it up again? Seems like a lot of work for very little (if any) benefit.
The problem can be that a work table like this is normally empty so the CBO will go for a FTS - OK if the HWM is not at 5'000 blocks. After you do a BIG job, you want a way to get the HWM down to a reasonable level (or persuade the CBO to use an index).