Where we use PPI in real time??? What is the disadvantages
of PPI?

Answers were Sorted based on User's Feedback



Where we use PPI in real time??? What is the disadvantages of PPI?..

Answer / yuvaevergreen

PPI arranges the rows in a data block using the value that
we mention in ddl. Range processing would be faster.
Basically rowid would not be used instead value would be used.


create table emp
(
emp char(10),
hiredate date
)
upi(emp)
partition by range_n
(hiredate between date '2000-10-10' and date '2010-10-10'
each interval '1' year);

Is This Answer Correct ?    5 Yes 1 No

Where we use PPI in real time??? What is the disadvantages of PPI?..

Answer / yuvaevergreen

Disadv: Joins to Non-Partitioned Tables can take longer.
Additional overhead of two-byte Partition number.

Is This Answer Correct ?    2 Yes 1 No

Where we use PPI in real time??? What is the disadvantages of PPI?..

Answer / 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

More Teradata Interview Questions

I have all the TERADATA Certification Dumps for the below: NR0-011, NR0-012, NR0-013, NR0-014 NR0-015 NR0-016, NR0-017 If anyone need it, pls drop me a mail with Code in the mail to: terashish@gmail.com

201 Answers   Cognizant, Deloitte, IBM, Prometric, Syntel,


How to select first n records in teradata?

0 Answers  


can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,


what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,


what is identity columns in teradata

2 Answers   Wipro,






Can you load multiple data files for same target table using fastload?

1 Answers  


Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  


How would you load a very large file in teradata in general? What utility would you use for it? Why?

0 Answers  


What are the updated features of teradata?

0 Answers  


Why MLOAD needs Work Tables?

5 Answers   Teradata,


Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,


What is oltp?

0 Answers  


Categories