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 are differences between teradata and ansi session modes in teradata?

1124

What are the various indexes in teradata? How to use them?

978

How do you verify a complicated sql?

1036

What is the command in bteq to check for session settings ?

1139

How do you define Teradata?

1011

What is the difference between fastload and multiload? Which one is faster?

1169

How to view every column and the columns contained in indexes in teradata?

1003

Explain vproc in teradata?

951

How is MLOAD Teradata Server restarted after execution?

1200

What is the difference between teradata and oracle?

980

Describe primary index in teradata. And what are the available primary index types?

965

What is meant by a Highest Cost Plan?

1012

Comment whether bottleneck is an error or not.

1101

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

981

In general, how do you optimze any sql in teradata?

1002