Archives of the TeradataForum
Message Posted: Tue, 31 Jul 2012 @ 13:13:02 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 23 Jun 2019|