Archives of the TeradataForum

Message Posted: Wed, 24 Jan 2007 @ 18:50:50 GMT

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

<-- Anonymously Posted: Wednesday, January 24, 2007 13:22 -->

Per Data Dictionary manual:

Q= PPI (P is non-partitioned PI)

M= Multi-column statistics (collected when no corresponding index existed)

K= Primary Key constraint

Also note that S is only for "ordinary" Secondary indexes. There are separate IndexTypes for "covering" and/or "value-ordered" secondary indexes.

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