Lonny Niederstadt has a new series on usability “soft spots” with Query Store. Part one looks at plan identifiers:
Yeah. That’s a lotta plans in the right-hand legend. 22 of them. In a not very helpful order. In fact… though I’ve tried to figure it out, I don’t know what type of order is used for that right-hand legend. It’s not chronological. It’s not based on duration which is the metric displayed by the graph. I dunno.
Part two looks at “morally equivalent plans”:
Let’s refresh the “Tracked Queries” activity.
Ohhhh. I forced plan_id 2 (in the purple box below) but what showed up was plan_id 3220 (in the yellow box below).
Lonny promises more, so keep on the lookout.