Archives of the TeradataForum
Message Posted: Wed, 23 Mar 2005 @ 20:09:11 GMT
| Subj: | | Re: Statistics and collection date |
| |
| From: | | Kumaran Anantaraman |
On Tue, 1 Apr 2003 16:55:48 -0500, Anomy Anom wrote:
| | Is there some way to get the date that statistics were updated using SQL without using 'help statistics ...'? | |
The suggestions proposed in this thread (fieldstatistics, and LASTALTERTIMESTAMP field in DBC.TVFIELDS) seem to work for single-column
statistics.
(1) How do I find the collection date for a multi-column index?
(2) Is there a reason why the collection date is not exposed in the views dbc.columnstats and dbc.indexstats?
| 
