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
How do you see a ddl for an existing table?
What do high confidence, low confidence and no confidence mean in explain plan?
What is stored procedure in teradata?
Why is the case expression used in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
What's the difference between timestamp (0) and timestamp (6)?
What are the various indexes in teradata? Why are they preferred?
How to view every column and the columns contained in indexes in teradata?
Differentiate primary key and partition key?
Explain and compare pros and cons of snow flake schemas?
What are the different table types that are supported by teradata?
What are normalization, first normal form, second normal form and third normal form?
Explain fallback in teradata?
Highlight the need for Performance Tuning.
What are the various etl tools in the market?