Where we use PPI in real time??? What is the disadvantages
of PPI?
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
How do you define Teradata?
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is real time and near real time data warehousing?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the available primary index types?
What are the different functions performed in development phase?
What's the difference between timestamp (0) and timestamp (6)?
What are the different functions included in the server software?
What is the opening step in basic teradata query script?
what is sysdba and sysdbc ? which has high priority ?
What is the basic syntax for teradata select statement?
What does sleep function does in fast load?
What is the purpose of joins in teradata?
How to run a query in teradata?
What is the use of virtual processor connectivity in teradata?