Archives of the TeradataForum
Message Posted: Wed, 31 Oct 2007 @ 11:22:43 GMT
<-- 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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|