Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8516 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
What is the syntax for case when statement?
What is bteq script in teradata?
What are differences between teradata and ansi session modes in teradata?
What are the available primary index types in teradata.
What is bteq utility in teradata?
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?
What is the purpose of joins in teradata?
What are the different softwares used with their functions in teradata?
Explain teradata vs. Redshift?
How to view every column and the columns contained in indexes in teradata?
Difference between multiload and tpump?
Explain amp in teradata?
Explain the types of join supports by teradata?
What is meant by a Parsing Engine?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
