Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 20705 Views
- Satyam, I also Faced
- E-Mail Answers
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 is a level of granularity of a fact table?
What are the uses of bynets in multi-node systems?
Explain Teradata performance tuning and optimization?
Highlight the points of differences between the database and user in Teradata.
What are the primary characteristics of the Teradata.
if collect stats but it show low confidence why?
What are the functions involved in shared information architecture?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the updated features of teradata?
Explain amp in teradata?
Describe primary index in teradata?
What is node? How many nodes and amps used in your previous project?
What is a sparse index?
what is object level locking ? where do appear this type of locking ?
What is TPD?
