Archives of the TeradataForum
Message Posted: Sat, 21 Nov 2009 @ 10:27:44 GMT
I just re worked a BO Query and got things to acceptable SLA. I noticed these steps in the explain and wonder WHY would the optimizer bother to do them
32 0:44.08 5:06.90 6011942 473720300
33 0:44.08 6011942
So per the above 31104 is locally built on AMP's - fine. So why is is AGAIN selecting * from 31104 and repeating the process and building the same locally on the AMP's. The row estimates are also the same and Step # 33 is turning out to be a bit costlier than Step # 32 . Why Step # 33 Any idea how this can be avoided .
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|