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 maximum number of dml can be coded in a multiload script?

1109

Highlight a few of the advantages that ETL tools have over Teradata.

1090

What is oltp?

979

Differentiate database data and data warehouse data?

1120

What is the purpose of using case expression in teradata?

1017

what is object level locking ? where do appear this type of locking ?

3502

What are the available primary index types in teradata.

1034

What is the use of stored procedures in teradata?

1007

What is called partitioned primary index (ppi)?

1013

What are the different design perspectives used in teradata?

983

Explain fastload in teradata?

1111

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

1022

What is collect statistics?

1004

Can you fastexport a field, which is primary key by putting equality on that key?

1180

Highlight the limitations of TPUMP Utility.

1112