Interested to Buy Any Domain ? << Click Here >> for more details...
What is Difference b/w PI & PPI?how to implement PPI?
- 3 Answers
- 8005 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
what is object level locking ? where do appear this type of locking ?
What are the various indexes in teradata?
What is the purpose of indexes?
Can we collect statistics on multiple columns?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Explain the term 'row' related to relational database management system?
What are the various indexes in teradata? Why are they preferred?
Write a program to show the parser component used in teradata?
What are the functions of a teradata dba?
What are the uses of bynets in multi-node systems?
What is meant by a Parsing Engine?
What is real time and near real time data warehousing?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is partitioned primary index (ppi)?
Why teradata is used?
