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
What are the available join types in teradata?
Explain Teradata performance tuning and optimization?
Explain how spool space is used.
Difference between stored procedure and macro?
Explain and compare pros and cons of snow flake schemas?
Explain teradata vs. Redshift?
What is meant by Teradata Gateway?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
if collect stats but it show low confidence why?
What are the 5 phases in a multiload utility?
What do you mean by caching in teradata?
What is the primary index in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What is a node in teradata? Explain
How many codd's rules are satisfied by teradata database?