Re: Why could GEQO produce plans with lower costs than the standard_join_search?

>>>>> "Finnerty" == Finnerty, Jim <jfinnert@amazon.com> writes:

 Finnerty> planstate-> total_cost    cheapest_total_path
 Finnerty>     GEQO        54190.13        54239.03
 Finnerty>     STD        54179.02        54273.73

These differences aren't significant - the standard join search has a
"fuzz factor" built into it, such that paths have to be more than 1%
better in cost in order to actually be considered as being better than
an existing path.

-- 
Andrew (irc:RhodiumToad)