Plansplaining part 35. A bug in Table Spool and an invisible property on Stream Aggregate
No Comments
Welcome back to the plansplaining series. Probably the one with the longest, and least clickbaity title. The idea of plansplaining is to take a single execution plan and then fully dissect it, until every little thing that is happening is fully exposed and clarified. However, I am only human. I may miss things. And in this case, some things I missed in one of the earliest plansplaining posts are sufficiently interesting to return to that post and talk about the little details that don’t match up, and then make them match up. Frameless window The OVER clause, that can be…
