 |
 |
Archives of the TeradataForum
Message Posted: Wed, 19 Nov 2008 @ 20:03:40 GMT
| Subj: | | Re: Stats collection on Index Column |
| |
| From: | | Michael Larkins |
It was written earlier:
| | Ideally you should collect stats on every index - be it UPI, NUPI, USI or NUSI... especially NUSI as it might help optimizer choose it over
Full Table Scan. | |
Although the NUSI comment is absolutely correct, I question the need for stats on a USI. It is always a two-AMP operation with or without
stats. Since each set of stats can take a far amount of time on a larger table, I would strongly rethink the need for them on a USI.
Regards,
Michael Larkins
Certified Teradata Master
Certified Teradata SQL Instructor
| |
