Memory Grant - Not clear

  • In my attached execution plan when i hover over the Update statement it shows Memory grant as 22 gb and if i scroll all the way to right the Actual data size on left outer join on table2 and table 12 is 43 gb, i am not clear how estimated data size of operators can be more than actual Memory grant?

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply