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

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the purpose of using case expression in teradata?

575


Explain teradata architecture?

638


How is MLOAD Client System restarted after execution?

604


If RDBMS is halted what will you do ?

1711


How do you verify a complicated sql?

635






What are different table types used in teradata?

590


Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

1624


What is the basic syntax for teradata select statement?

580


Why managing the data is important?

594


Can you connect multiload from ab initio?

647


What is a sparse index?

634


Explain PDE.

608


What are the joins in teradata?

573


How many codd's rules are satisfied by teradata database?

666


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

591