![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 31 Oct 2007 @ 11:22:43 GMT
Subj: | | Secondary Indexes Stats and Usage |
|
From: | | Anomy Anom |
<-- 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
| |