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
(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?