The first join order always has a 'Best so far'
because it is the only join so far. After that,
'Best so far' should only appear when a better
(cheaper) join order is found. In this case,
it looks as if the first one checked was the
best.
For a three table join, I can spare the time to
have a quick look at the trace file if you think
it is odd. Feel free to email it direct to me.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/seminar.html
Public Appearances - schedule updated Jan 21st 2005
"Spendius" <spendius_at_muchomail.com> wrote in message
news:aba30b75.0502230132.43fdc753_at_posting.google.com...
> For example how come you do not find any cost calculation
> any further than the first attempt ?!? (we do have our
> factorial(3) join combinations), why is there no more
> "Best so far" line here ?:
>
> # >egrep "^Best so f|^Join ord" bened01p_ora_22222.trc
> Join order[1]: ABC_DEFG [DI] ABC [ D] ABC_DEF_GHI [DPE]
> Best so far: TABLE#: 0 CST: 10158 CDN: 1269 BYTES:
> 29187
> Best so far: TABLE#: 1 CST: 12696 CDN: 1269 BYTES:
> 88830
> Best so far: TABLE#: 2 CST: 16523 CDN: 1279 BYTES:
> 106157
> Join order[1]: ABC_DEFG [DI] ABC [ D] ABC_DEF_GHI [DPE]
> Join order[2]: ABC_DEFG [DI] ABC_DEF_GHI [DPE] ABC [ D]
> Join order[2]: ABC_DEFG [DI] ABC_DEF_GHI [DPE] ABC [ D]
> Join order[3]: ABC [ D] ABC_DEFG [DI] ABC_DEF_GHI [DPE]
> Join order[3]: ABC [ D] ABC_DEFG [DI] ABC_DEF_GHI [DPE]
> Join order[4]: ABC [ D] ABC_DEF_GHI [DPE] ABC_DEFG [DI]
> Join order[4]: ABC [ D] ABC_DEF_GHI [DPE] ABC_DEFG [DI]
> Join order[5]: ABC_DEF_GHI [DPE] ABC_DEFG [DI] ABC [ D]
> Join order[5]: ABC_DEF_GHI [DPE] ABC_DEFG [DI] ABC [ D]
> Join order[6]: ABC_DEF_GHI [DPE] ABC [ D] ABC_DEFG [DI]
> Join order[6]: ABC_DEF_GHI [DPE] ABC [ D] ABC_DEFG [DI]
Received on Wed Feb 23 2005 - 17:29:30 CST
