Archives of the TeradataForum

Message Posted: Wed, 04 May 2011 @ 15:10:32 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

HI,

Use

     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.

Thanks

Machha

	<Prev	Next>		<<First	<Prev	Next>	Last>>