|
|
Archives of the TeradataForum
Message Posted: Tue, 31 Jul 2012 @ 13:13:02 GMT
Subj: | | Re: Automatic Script to collect stats on index and defined columns |
|
From: | | Gregg, William |
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
| |