Archives of the TeradataForum

Message Posted: Fri, 20 Jun 2003 @ 16:29:56 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

On the topic of statistics:

I have a primary index defined on a table that doesn't have a name and a secondary index that is named.

If I run a 'collect statistics on tblA' will it grab statistics for all indices? Can I verify that the statistics were updated? I was thinking I could look at the LastAlterTimeStamp in the dbc.indices table? Is there a better way?

Thoughts?

Thanks in advance.

Dave Harper

	<Prev	Next>		<<First	<Prev	Next>	Last>>