> The basic promise of a query optimizer is that it picks a good plan all of the time. The poster you responded to is correct, it's a combinatorial problem tha

> The basic promise of a query optimizer is that it picks a good plan all of the time. The poster you responded to is correct, it's a combinatorial problem that can't be expected to pick a good plan all of the time within the normal data and time constraints.