Archives of the TeradataForum
Message Posted: Mon, 15 Oct 2001 @ 21:15:30 GMT
It's up to 100 intervals with informatio about:
Max Value, #records and #other values within interval, #records
Jim Calvert's InTeraStats is available from
Newer versions of Teradata Manager (4.2 up?) provide the same information now 'officially' and using the stats tool you're now even able to fool the optimizer by modifying statistics (if you know what you do).
It's a cost based optimizer and sometimes it's just misscalculating the costs. Look at the statistics, especially the skewed values, there could be entries for all the skewed values (but i don't know if this was already included in R3).
btw, did you collect statistics on the single row table MD_DWE_Date?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|