Archives of the TeradataForum

Message Posted: Thu, 21 Jul 2011 @ 20:26:43 GMT

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

The view DBC.Indices, where the IndexType is 'P' (and you can see others) and the ColumnPosition says where it is in the index. Don't be fooled by the table DBC.Indexes, which is a more "internal" table.

Btw, why the heck do we use "indices" and "indexes"? WikiDictionary says:

----------------
indices

1.Plural form of index (when used in the sense of a key to locate an element in a list, vector or matrix in computing or mathematics) The subscript numbers after each element are the indices of that element.

A common convention in computing is to have indices beginning at zero, whereas in mathematics indices usually begin at one.

Usage notes

Both plurals are in common use. The OED claims that when referring to a directory listing, the plural indexes should be used.

---------------

Ok, guys, do we have a catalog or a dictionary for Teradata? And what is the air speed of a swallow?

iv

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