Interested to Buy Any Domain ? << Click Here >> for more details...
Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 10707 Views
- IBM, Mphasis, I also Faced
- E-Mail Answers
Answer Posted / tdguy
adv: If the query uses a range within the partition, FTS
can be avoided. faster than secondary index, if used
properly. Deletion of partitions is fast.
disadv: when joined to non partitioned table, may take
long time to process.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What do you mean by teradata intellicloud?
Explain the meaning of Amp?
What is partitioned primary index (ppi)?
What are default access rights in teradata? What explicit right can be given to a user?
If RDBMS is halted what will you do ?
Different phases of multiload?
What are the frequently used data types in teradata?
Difference between star and snowflake schemas?
How you will check the version of teradata?
What are the various etl tools in the market?
What is upsert statement in teradata?
What are the different functions performed in development phase?
How is MLOAD Client System restarted after execution?
In Teradata, what is the significance of UPSERT command?
What are normalization, first normal form, second normal form and third normal form?
