NOTE: If you see Stream aggregate instead of Hash aggregate in the plan, for some reason SQL Server don't thinks that 9999999 rows with type=2 is enough for this plan. In that case, add more rows with type=2 into the flgp table by repeating the following query several times:
|Average query CPU time changed from 124.38ms to 2035.61ms||43||exec sp_query_store_force_plan @query_id = 2, @plan_id = 2||2||14||2||118.496206423913||NO|
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.