> 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.
Hmmm...with PREPARE and EXECUTE, would it be possible to somehow get the
planner to actually run a few different selects and then actually store the
actual fastest plan? I'm being very fanciful here, of course...
Chris