Archives of the TeradataForum
Message Posted: Wed, 12 Mar 2003 @ 15:45:09 GMT
For all recent releases of Teradata, statistics are vital if the optimiser is going to get the correct join plan. If you don't have stats on the PI of a table then the optimiser will ignore any other stats that are collected on the table.
Stats help the optimiser with row count, data value skewing within a column etc. There are some access paths which typically will not be chosen unless there are stats on the relevant column/index (e.g. value-ordered nusi).
I think you'll find that the general consensus is that stats are no longer optional, they are a requirement.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|