Archives of the TeradataForum

Message Posted: Tue, 13 Dec 2011 @ 08:44:57 GMT

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

Hi YB,

I think this query will not return table names (or rather correct results) because every table (having PI) will have an entry in dbc.Indexes regardless of stats collection.

     indexstatistics = null          when stats are not collected
     indexstatistics = not null      when stats are collected

View DBC. IndexStats will return indexes defined on the table with stats details, it does not care about 'NULL' in the indexstatistics field.

Thanks,

Vipin Gupta

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