How to find tables that have a PPI

Database
Enthusiast

How to find tables that have a PPI

Are there any dbc views that I can query to find the database.tablename of any tables that have a partitioned primary index?
Thnx,
Marius
7 REPLIES
Teradata Employee

Re: How to find tables that have a PPI

DBC indices is the view you need to query for any index related information.

for PPI, the following query will give you the details of PPI

SEL * FROM dbc.indices
WHERE indextype = 'Q'
AND databasename = 'yourDBname' -- optional to restrict the result set--

Latesh
Enthusiast

Re: How to find tables that have a PPI

You can also query dbc.indexconstraints for columns with constrainttype 'Q'. You can also view the PPI Expression in the column constrainttext in this table.
Enthusiast

Re: How to find tables that have a PPI

Thanks Leo, indextype is exactly what I need...Marius
Enthusiast

Re: How to find tables that have a PPI

Thank you also Latesh...Marius
Enthusiast

Re: How to find tables that have a PPI

This helped me too.  Thank you.

Teradata Employee

Re: How to find tables that have a PPI

Hi,

Is there any easy way to find the expiring partitions in Teradata. A query or macro that will list the table names with expiring partitions.

Teradata Employee

Re: How to find tables that have a PPI

thanks,

very usefull tip!

Tags (1)