Home Page for the TeradataForum

Archives of the TeradataForum

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

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

Subj:   Re: Primary Index Column
From:   frank.c.martinez

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:


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?


  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023