Archives of the TeradataForum
Message Posted: Wed, 21 Nov 2012 @ 20:09:31 GMT
Subj: | | Excessive Stats |
|
From: | | Anomy Anom |
< -- Anonymously Posted: Wednesday, November 21, 2012 10:17 -- >
Is there any way to find out if excessive stats have been collected on some tables?
How to determine how frequently stats need to be collected? You leave this up to the application development team (who knows how frequently
data changes by 10% and determine when to refresh the stats , either daily or weekly or monthly)
Or do you have any other way of doing it intelligently?
Thanks in advance.
|