Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 9274 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 are the joins in teradata and how many types of joins are there in teradata?
Explain the term 'tables' related to relational database management system?
Explain the term 'columns' related to relational database management system?
What are the things to be considered while creating secondary index?
What are the uses of client software involved in teradata?
List out some of the primary characteristics of teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Highlight a few of the advantages that ETL tools have over Teradata.
What is a sparse index?
In BTEQ, how are the session-mode parameters being set?
Explain and compare pros and cons of start schemas?
What are the functions performed by bynet?
What are tpump utility limitations?
What are the available primary index types?
Explain the most common data types used in teradata?
