Archives of the TeradataForum
Message Posted: Wed, 20 Feb 2008 @ 09:33:31 GMT
| Subj: || || Re: High confidence in Explain |
| From: || || ulrich arndt |
one reason could be that new data had been loaded to the table after the stats had been collected. Stats are not refreshed automatically and
therefore the recommendation is that you should recollect stats if ~5% of the data changed. But this is not an absolut recommendation. As it is
only required to refresh the stats in case the demographic changed - which might have happened in your case.