Where we use PPI in real time??? What is the disadvantages
of PPI?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
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?
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?
what is identity columns in teradata
Can you load multiple data files for same target table using fastload?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are the updated features of teradata?
Why MLOAD needs Work Tables?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What is oltp?