Archives of the TeradataForum

Message Posted: Mon, 22 Aug 2005 @ 17:07:53 GMT

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

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.

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