3 ms·
Oracle is pretty smart about this, if a new plan is slower than the previous one, it seamlessly flips back.
by gaius 15y ago
Oracle is pretty smart about this, if a new plan is slower than the previous one, it seamlessly flips back.
- politician 15y agoJIT compilers have been doing hotspot recompilation for a while now. Is there a reason why databases haven't adopted the same techniques? Is there some barrier to caching multiple query plans optimized for different load scenarios?
- gaius 15y agoWhat do you mean by "load scenario"? The only thing that should affect the plan is the characteristics of the underlying data (e.g. do we expect to return so many rows that we should full-scan anyway, or can we use an index).