Archives of the TeradataForum
Message Posted: Thu, 17 Jan 2008 @ 13:06:05 GMT
The reason that it might want to join one of your fact tables to a smaller table is that it thinks by joining to it, it will eliminate some rows. It looks like it wants to join ORDERHEADER to CUSTOMER and when it does this, it has a "no confidence" estimate. Try collecting stats on the CUSTOMER_ID in ORDERHEADER and see if that makes a difference.
The estimates shown are not very large. The optimizer will be more willing to move tables around if it's working with small tables. If your ORDERHEADER and ORDERDETAIL were much larger, then the optimizer will tend to join them together before moving them around.
Hope that helps.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|