Re: Reallife szenario for GEQO

On Tuesday 13 January 2004 09:50, Bernd Helmle wrote:
> Have anyone made such a comparison, or have experiences
> which szenarios, where the GEQO has improved the query plan generation
> in contrast to "traditional" solutions? This will be very helpful (and
> interesting) ....

I don't think it's that it provides a better plan, just that it comes up with
a quicker solution. Searching all possible paths is not practical for a large
number of tables, so you need another approach.

Google for "travelling salesman problem" for discussion of the sort of
thinking behind it.

--
  Richard Huxton
  Archonet Ltd