Partioned Primary Index Table

Database
Enthusiast

Partioned Primary Index Table

Hi I am Jeevan

I have a question regarding PPI

Why do we cannot have a Unique Primary Index in PPI table where the partioning collumn is not a part of Primary Index?

I was confused alot with this statement, please calrify me

Thanks
Jeevan
1 REPLY
Enthusiast

Re: Partioned Primary Index Table

This seems to be a recurring question. See the following discussion thread:

http://www.teradata.com/teradataForum/Topic6553-9-1.aspx?Highlight=PPI+UPI