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
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Explain the term 'tables' related to relational database management system?
What is multi insert?
What is primary index and secondary index?
What is the difference between union and union all in teradata?
What is smp and mpp platforms?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
How you will check the version of teradata?
What are the available primary index types?
How do you see a ddl for an existing table?
What is the use of fallback?
What is meant by a Highest Cost Plan?
In Teradata, how do we Generate Sequence?
What do you mean by teradata sql assistant?