Disadv: Joins to Non-Partitioned Tables can take longer. Additional overhe

Where we use PPI in real time??? What is the disadvantages
of PPI?

Question Posted / yuvaevergreen

Answer Posted / 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

Please Help Members By Posting Answers For Below Questions

What is the function of parser component in teradata?

1078

How would you load a very large file in teradata in general?

1032

Highlight the limitations of TPUMP Utility.

1111

Explain Teradata performance tuning and optimization?

1157

Difference between stored procedure and macro?

1168

Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

2412

Highlight the advantages of PPI(Partition Primary Index).

1072

What is basic teradata query language?

1109

What is meant by a Parsing Engine?

1184

Can we collect statistics on multiple columns?

1057

Highlight the need for Performance Tuning.

1103

What is spool space? Why do you get spool space errors?

1015

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1093

What is spool space?

1149

What do high confidence, low confidence and no confidence mean in explain plan?

1043