Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 9254 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 is the meaning of Caching in Teradata?
What is the syntax for case when statement?
What are teradata utilities?
How to view every column and the columns contained in indexes in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
What is meant by a node?
Explain teradata utilities?
Describe primary index in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How is the teradata different from oracle?
Explain the most common data types used in teradata?
Discuss the advantages of using partitioned primary index in a query?
What do you mean by teradata intellicloud?
What is the use of having index on table?
What are the functions performed by bynet?
