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
- 10705 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 |
Highlight a few of the advantages that ETL tools have over Teradata.
How does hashing happens in teradata?
Find 2 highest sal from each dept who have completed 5 year in org
What is database exceptions in teradata?
suppose one Cylinder split data blocks are moved from where?
What are the various indexes in teradata? How to use them?
What do you mean by teradata sql assistant?
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
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What is the purpose of upsert command?
why varchar takes 2 extra bytes?
What is the use of upsert command in teradata?
Teradata 
