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
- 10741 Views
- IBM, Mphasis, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What do you mean by fastexport in teradata?
What are the things to be considered while creating secondary index?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What are the joins in teradata?
What is the use of stored procedures in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
Which is more efficient group by or distinct to find duplicates?
How do you do backup and recovery in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
What is the multi-insert?
What is the maximum number of dml can be coded in a multiload script?
What's the difference between timestamp (0) and timestamp (6)?
What are the uses of client software involved in teradata?
Syntax for case when statement?
What are the steps involved in the process flow of the sql statement through channel attached system?
