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?
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.
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.
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 :)
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