Archives of the TeradataForum

Message Posted: Fri, 13 Oct 2006 @ 20:29:18 GMT

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

<-- Anonymously Posted: Friday, October 13, 2006 16:13 -->

COLLECT DEMOGRAPHICS ... ALL will give you count / average size information for index subtables.

Easiest way I've found to create a matching table definition but without secondary indexes: SHOW TABLE, remove any INDEX lines after the PRIMARY INDEX one.

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