Archives of the TeradataForum

Message Posted: Tue, 31 Jul 2012 @ 13:13:02 GMT

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

Hi -- perhaps the biggest advantage of naming all indices is that statistics collection may be done by referencing the name of the index rather than citing all the columns in the statement.

If your indices are not named, consider doing so. A naming standard using a suffix of_x01, _x02, _x03, etc. for the Idxs will work well.

Rgrds,

Bill Gregg

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