>>>>> "Finnerty" == Finnerty, Jim <jfinn...@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)