All Forums Data Modeling
M.Saeed Khurram 544 posts Joined 09/12
30 Nov 2013
PPI VS NPPI

hi,
When we partition a table based on PI it is called PPI, and if a table is not partitioned on PI, then it is called NPPI, my question is that is there any specific terminology about a table partitioned on non PI columns? Or we will simply call it PPI?
For example, a table orders has a defined PI order_ID, but is partitioned on some other column say Order_Date, it will be called the same PPI or some other term is there by Teradata?
 

Khurram

dnoeth 4628 posts Joined 11/04
01 Dec 2013

Hi Khurram,
afaik there's no such term, UPI/NUPI/USI/NUSI/VOSI/NoPI/PPI/MLPPI/CPPI/JI/AJI/HI are more than enough :-)
I never use NPPI, it's just the same as PI, a table which is not partitioned. 

Dieter

Raja_KT 1246 posts Joined 07/09
01 Dec 2013

We have NoPI tables. Also we can have table or join index  of column partitioned table that can have no Primary index.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

M.Saeed Khurram 544 posts Joined 09/12
01 Dec 2013

Hi Diether,
Thank you very much for the kind response, it was a confusion, I got the answer laters :)
Even if partition is not based on PI, the distribution is based on PI, and the rows are still sorted using P#/RH#. So we can call it PPI.
 

Khurram

M.Saeed Khurram 544 posts Joined 09/12
01 Dec 2013

Thank you Raja for the response, But I was thinking if there is a term used for Table Partitioned by a column other than PI. It was just a confusion and I got it laters :)
 

Khurram

Raja_KT 1246 posts Joined 07/09
01 Dec 2013

You are welcome.  Yes it is Column-Partitioned Tables, and Column-Partitioned Join Indexes.
Cheers,
Raja

Raja K Thaw
My wiki: http://en.wikipedia.org/wiki/User:Kt_raj1
Street Children suffer not by their fault. We can help them if we want.

You must sign in to leave a comment.