PPI VS NPPI

Data Modeling
Enthusiast

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
Tags (1)
5 REPLIES
Senior Apprentice

Re: PPI VS NPPI

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. 

Enthusiast

Re: PPI VS NPPI

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

Cheers,

Raja

Enthusiast

Re: PPI VS NPPI

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
Enthusiast

Re: PPI VS NPPI

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
Enthusiast

Re: PPI VS NPPI

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

Cheers,

Raja