Archives of the TeradataForum
Message Posted: Mon, 22 Aug 2005 @ 17:07:53 GMT
Did you try collecting stats on the column before adding an index? It may be that the performance improvement was due to the stats rather than the nusi. I've found that the secondaries need to be more like 99% selective before they become useful.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|