Interested to Buy Any Domain ? << Click Here >> for more details...
Where we use PPI in real time??? What is the disadvantages
of PPI?
- 3 Answers
- 10572 Views
- IBM, Mphasis, I also Faced
- E-Mail Answers
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 |
What is Difference b/w PI & PPI?how to implement PPI?
What is the Maximum number of volatile tables that can be created?
In Teradata, how do we Generate Sequence?
if a error occured in FASTLOAD is the fastload job stops?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How can you track login parameters of users in teradata?
what is sysdba and sysdbc ? which has high priority ?
Which Teradata concept allows more than one model generation?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,
What is the diffrence between Multiload & Fastload interms of Performance?
How can we load single row of data into teradata database. please give me the process.
Explain teradata architecture?
Teradata 
