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
- 10849 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 do you mean by fastexport in teradata?
What are the components provided on node?
Describe primary index in teradata. And what are the available primary index types?
Explain the term 'foreign key' related to relational database management system?
What do you mean by parsing?
what is the difference between start schma and Fsldm?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
write lock is compatiable with which type of lock?
What is bteq script in teradata?
What is the basic syntax for teradata select statement?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Teradata 
