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 do you mean by teradata intelliflex?

1167

What is the basic syntax for teradata select statement?

1096

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

1144

Did you write stored procedures in teradata?

1187

Explain some differences between mpp and smp?

1157

What are the various indexes in teradata? Why are they preferred?

1053

What is the use of teradata system software?

1088

What is meant by a Clique?

1114

What are the primary characteristics of the Teradata.

1236

What is partitioned primary index (ppi)?

1086

What is the purpose of upsert command?

1261

What do you mean by teradata intellicloud?

1077

Explain the term 'foreign key' related to relational database management system?

1116

Name the five phases that come under MultiLoad Utility.

1032

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1213