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 |
Explain and compare pros and cons of start schemas?
What is partitioned primary index (ppi)?
What do you mean by teradata sql assistant?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
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.
In BTEQ, how are the session-mode parameters being set?
In your project what type of issues and errors you facing in Teradata
What are the updated features of teradata?
What is teradata and why it is used?
What can be achieved by using the teradata rdbms?
A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?
Give the sizes of SMALLINT, BYTEINT and INTEGER.