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
- 10746 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 |
How many macros we can create inside a macro
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What do you mean by tpt in teradata?
what is sysdba and sysdbc ? which has high priority ?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Syntax for case when statement?
What is meant by a Least Cost Plan?
What is the primary index in teradata?
Difference between multiload and tpump?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
How to run the Teradata jobs in unix environment ???
Teradata 
