What is Difference b/w PI & PPI?how to implement PPI?
Answer Posted / tdguy
PI is mandatory in TD. Data distribution in TD depends on
PI. The PI more unique, more will be the performance. PPI
is generally used for range processing.TD stores data
within a block based on row id. But PPI stores the rows in
a data block by the value instead of the ROWID. Therefore,
range processing will be faster.
partition by statement is used along with create statement.
range for weeks or months or days can be mentioned by using
interval option.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Can you fastexport a field, which is primary key by putting equality on that key?
What are the functions performed by bynet?
What are the multiload utility limitations?
What is logical data model?
Explain teradata utilities?
What are the functions of a teradata dba?
Explain the meaning of Amp?
Explain the term 'database' related to relational database management system?
What are the string manipulation operators and functions associated with teradata?
Explain teradata architecture in detail with a diagram.
Explain BYNET.
How to eliminate product joins in a teradata sql query?
Explain amp in teradata?
What is partitioned primary index (ppi)?
What is the syntax for case when statement?