How to identify PPI columns

Analytics

How to identify PPI columns

Hi , Is there a way to identify columns used for partitoning either in PPIs or MLPPIs

select databasename , tablename , columnposition ,columnname from dbc.indices
where indextype ='Q'
order by 1 ,2,3 ;

brings back the PI of the table , not the partitioning columns . I can't see anything else to use ??
Any help much appreciated.

Regards

SF
4 REPLIES
Junior Supporter

Re: How to identify PPI columns



There are no such things as 'partitioning columns' but 'partitioning EXPRESSIONS' -which can be, of course, based on column values, but they are different things-.

HTH

Cheers.

Carlos.

Re: How to identify PPI columns

That helps a bit yes -I see the distinction

So.... is there any way you know of to get the partion xpression from the dictionary :-)

Regards

SF
Junior Supporter

Re: How to identify PPI columns

Show table?

HTH.

Cheers.

Carlos.
Senior Apprentice

Re: How to identify PPI columns

dbc.indexconstraints contains a CHECK with the partition expression.

Dieter