Interested to Buy Any Domain ? << Click Here >> for more details...
How does indexing improve query performance?
- 4 Answers
- 20625 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 are the scenarios in which full table scans occurs?
What is dimensional modeling?
Highlight the differences between Primary Key and Primary Index.
How will you solve the problem that occurs during update?
what is sysdba and sysdbc ? which has high priority ?
Difference between star and snowflake schemas?
What is teradata? What are some primary characteristics of teradata?
What is the purpose of joins in teradata and what are the available join types?
Can we collect statistics on table level?
how do you manage the production space. what are the proactive methods you can take ?
What is teradata and why it is used?
What is meant by a dispatcher?
What is the purpose of joins in teradata?
List the logical and conditional operators that are used with teradata along with their meanings?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
