Thanks

I understand the workspace memory area (Well, I hope I do). A query will request required memory and once the query has been granted that, if it needs to, it will request additional memory for processing a hash join for example, which might have to spill to disk it memory can't accomodate that additional memory. Correct?

I'm not experiencing any particular issue, I'm just trying to understand the behaviour.

Where I got thrown off a bit was here

Thanks