Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8345 Views
- Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
PI is used for creating hash values and in turn, affects the
distribution of the rows across the amps. PPI is used to
partition the rows based on range of values. PPI is not
mandatory whereas PI is mandatory. PPI is generally used for
enhanced range processing. PPI can be used to avoid FTS,
thereby increasing the performance.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Difference between multiload and tpump?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What are the things to be considered while creating secondary index?
Describe the set operators in teradata.
What are the uses of bynets in multi-node systems?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Highlight the limitations of TPUMP Utility.
In general, how do you optimze any sql in teradata?
Describe primary index in teradata?
How to find duplicates in a table?
What is bteq utility in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
How is the teradata different from oracle?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What is partitioned primary index (ppi)?
