Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 9264 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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
List out all forms of LOCKS that are available in Teradata.
What are the components used in smp and massively parallel processing (mpp) machines?
What is a dimension table?
Syntax for case when statement?
Highlight the advantages of PPI(Partition Primary Index).
Explain teradata vs. Redshift?
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
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
any one answer me how they can analyzing the project using data ware housing?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Explain the term 'database' related to relational database management system?
What are the design features involved in teradata?
Explain the term 'tables' related to relational database management system?
Discuss the advantages of using partitioned primary index in a query?
