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
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.
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
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
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.
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