4 ms·
This highlights that there is space for an offline automated query omptimizer/rewriter, to compliment the online query planning?
by jononor 1y ago
This highlights that there is space for an offline automated query omptimizer/rewriter, to compliment the online query planning?
- dspillett 1y agoMS are tinkering with things a little in that direction with recent versions of SQL Server (usually in AzureSQL first then pushed to on-prem releases), though this is mostly around avoiding over-caching. A significant problem with query planners is that to make them better you make them slower, so you introduce caching, but that means you might end up using a bad plan when inputs change.