Re: Find a better plan than that computed by the optimizer ??

From: Spendius <spendius_at_muchomail.com>
Date: 23 Feb 2005 01:32:39 -0800
Message-ID: <aba30b75.0502230132.43fdc753@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 - 03:32:39 CST