What is Difference b/w PI & PPI?how to implement PPI?
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
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
if collect stats but it show low confidence why?
What is spool space? Why do you get spool space errors?
What are the uses of client software involved in teradata?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the components provided on node?
Explain the types of join supports by teradata?
During the Display time, how is the sequence generated by Teradata?
What is the basic syntax for teradata select statement?
What are the functions of a teradata dba?
What is the difference between teradata and oracle?
What is meant by a Channel Driver?
Explain teradata architecture in detail with a diagram.
What is teradata? Also, list out some of the primary characteristics of teradata.
What does Amp contain and what are all the operations that it performs?