3 ms·
Is not possible to make the query optimizer deterministic? I think is better that every time I see a query it do exactly the same steps. Only when testing/moni
by mamcx 8y ago
Is not possible to make the query optimizer deterministic?
I think is better that every time I see a query it do exactly the same steps. Only when testing/monitoring say so, I hint it.
- evanweaver 8y agoPerhaps. What if you add a new index and it changes the optimization plan of existing queries that you didn’t anticipate? There are a lot of edge cases, but we are not religiously opposed to making the optimizer smarter.
- mamcx 8y agoOh, I see. That make sense. In fact I like the idea of a RDBMS to be less of a black box.