Howcome this estimated plan has a Serial Desired Memory close to 550GB?
This is related to a query I posted earlier which spilled to tempdb which has 500GB space, filled it and failed. I am attempting to reduce the memory requirements of the same query by giving index seek hints. What I don't understand is this Query only has 1 hash join instead but now it's Serial Desired Memory is close to 550GB increased from 210GB. How is this value calculated?