How to find PPI (Partition Primary Index) tables in Teradata

All the index information in Teradata stored in dbc.indices dictionary and the index type for Primary index is ‘Q’

 SEL * FROM dbc.indices

WHERE indextype = 'Q'

AND databasename='<database name>';

 

Teradata considers PPI as constraints and also store the partition expression in dbc.indexconstraints

SEL * FROM dbc.indexconstraints

WHERE constraintType='Q'

AND databasename='<database name>';


Comments