…and how sparse tables can mess up your dynamic sampling.
A little lesson to self about paying attention to the detail, the obvious frickin’ detail. Getting older and slower.
We had one of those problems where a multitude of things were slow and yet there were no significant system-level problems (e.g. no general slow IO, no setting of the fast=false parameter, etc)
In such situations, if you check the high level system level...