4 ms·
And sometimes highly problematic. I'm surprised that the "query planner" doesn't have a way to eject an opaque object that is the "assembly language of the que
by bsder 2y ago
And sometimes highly problematic.
I'm surprised that the "query planner" doesn't have a way to eject an opaque object that is the "assembly language of the query" that you can run that it is not allowed to change.
- gpm 2y agoSure. It's definitely a tradeoff which definitely hurts on rare occasion. I agree that the lack of fallback in most databases is a bit strange. Altogether though the productivity benefits have proven larger than the drawbacks of not defaulting to a query planner.
- twoodfin 2y agoSeveral commercial databases offer this capability, under a term like “frozen plans”.