Archives of the TeradataForum
Message Posted: Tue, 22 Jul 2003 @ 16:02:28 GMT
Subj: | | Re: DBC view for Multi stats? |
|
From: | | John Hall |
I'm not sure what you mean by 'multi stats', but I assume you mean statistics.
The columns that contain the statistics are not available through views like DBC.COLUMNS or DBC.INDICES.
The statistics can be accessed using a couple of new views that were added with V2R4.1 called DBC.COLUMNSTATS (column FIELDSTATISTICS)
and DBC.INDEXSTATS (column INDEXSTATISTICS) - but only in a binary form.
|