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 |
Increasing no of amps will increase performance. Is this true?
Diff b/w v2r5 and v2r6 ?
What are the different table types supported by teradata?
How you will check the version of teradata?
How do you eliminate duplicates?
How many sessions of MAX is PE capable of handling at a particular time?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
Aborted in Phase 2 data acquistion completed in fastload?
How is MLOAD Client System restarted after execution?
how many modules are there in telecome domain?how to explain the architecture?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
what is identity column in TD?