Thomas Lockhart wrote:
>
>Systems which have optimizing planners can *never* be guaranteed to
>generate the actual lowest-cost query plan. Any impression that Oracle,
>for example, actually does do that may come from a lack of visibility
>into the process, and a lack of forum for discussing these edge cases.
>
I wholly agree... Oracle has some fairly *sick* ideas at times about
what to do in the face of partial ambiguity. (I've got a small set of
queries that will drive any machine with PeopleSoft DBs loaded to near
catatonia...) :)
As far as the 'planner benchmark suite' so we cans tart gathering more
statistical data about what costs should be, or are better at, that's an
excellent idea.
