All Forums Analytics
Superflash 4 posts Joined 01/08
13 Jan 2010
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.indiceswhere 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

CarlosAL 512 posts Joined 04/08
14 Jan 2010

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.

Superflash 4 posts Joined 01/08
21 Jan 2010

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 :-) RegardsSF

CarlosAL 512 posts Joined 04/08
22 Jan 2010

Show table?HTH.Cheers.Carlos.

dnoeth 4628 posts Joined 11/04
22 Jan 2010

dbc.indexconstraints contains a CHECK with the partition expression.Dieter

Dieter

You must sign in to leave a comment.