Yah Right. What I know that UPI give us some performance advantages over the PI. Please correct me If I am wrong. So, we want to define those keys as UPI.throbinson wrote:You mean a Primary Key. A Primary Index is how the data gets hashed across AMPS in a Teradata DBMS. They can be two very different things.
Search found 2 matches
- Sun Jan 25, 2009 4:25 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Setting a Teradata primary index for a write replace stage
- Replies: 11
- Views: 5767
- Fri Jan 23, 2009 4:03 pm
- Forum: IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- Topic: Setting a Teradata primary index for a write replace stage
- Replies: 11
- Views: 5767
Okay, answering my own question. It is late and my coffee has run out. After digging a bit more in the documentation I found the primary index option right in front of my nose. Not sure how I missed it. Anyway, thank you for sharing in my brain fart! Problem solved (drink more coffee before thinkin...