How does indexing improve query performance?
Answer Posted / yuvaevergreen
PI is very important in TD, because the data distribution
is basically dependent on PI.
1.Data distribution
2.Fastest way to retrieve rows
3.Important for joins
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
What does Amp contain and what are all the operations that it performs?
What are default access rights in teradata?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Highlight the need for Performance Tuning.
What is a node in teradata?
How do you define Teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
During the Display time, how is the sequence generated by Teradata?
How can bottlenecks be identified?
What are the joins in teradata and how many types of joins are there in teradata?
When tpump is used instead of multiload?
What are the components used in smp and massively parallel processing (mpp) machines?
what are the uses of fact table and dimension table in banking project?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How is MLOAD Teradata Server restarted after execution?