Thursday, October 7, 2010

How to find tables that have a PPI

In teradata we use lot of data dictionary tables (dbc)  to find definition/details about anything related to data.

How to find the tables which have PPI(partitioned primary index) ?
We make use of DBC.indices view to find any details regrading index.

Query :

SEL * FROM dbc.indices
WHERE indextype = 'Q'          ---- 'Q' means Partitioned Primary Index
AND databasename = 'DATABASENAME' ;

Infact , DBC.Indices can be used to find out various types of index associated with tables in a given database.

1 comment:

  1. This comment has been removed by a blog administrator.