Archives of the TeradataForum
Message Posted: Thu, 15 Jan 2004 @ 15:41:23 GMT
| Subj: || || Re: Collecting Statistics -- Question |
| From: || || PThomson2 |
| ||"A good compromise, if you are on V2R5, is to use the 'Collect Stats Using Sample' option. "|| |
Good point when we go to V2R5. Currently are on V2R4.1.3 and will be for a few more months anyway.
| ||"Otherwise, if this column will always have the same value, you should be able to collect regular statistics just once, and then
never collect them again (assuming you collect stats at the column level, and not the table level.)"|| |
We do collect stats at the table level; but for this particular job, I could probably modify.
Thanks for the suggestion.