Archives of the TeradataForum

Message Posted: Wed, 31 Oct 2007 @ 11:22:43 GMT

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

<-- Anonymously Posted: Wednesday, Tue, 30 Oct 2007 18:05 -->

I have many large secondary indexes at my Teradata installation, I am not sure whether they are being used or not, is there any way out I can see how many of them are used and how many aren't so that those indexes can be dropped .

also how find out stats are collected on these indexes , I can see stats on columns of the tables , does this means that stats are autmatically picked up by SIs

Thanks

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