Archives of the TeradataForum
Message Posted: Wed, 04 May 2011 @ 15:10:32 GMT
from dbc.indices where indextype='Q' --PPI and IndexStatistics is null
in your query and regarding collecting stats i don't think there will be any change if you collect stats on either any in some scenarios teradata recommend to collect stats on partition and on partition column also.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|