Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8522 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.
| Is This Answer Correct ? | 3 Yes | 0 No |
What are the joins in teradata?
Explain the term 'row' related to relational database management system?
What does sleep function does in fast load?
Explain teradata architecture?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
teradata support to automatically increase the character length or not?
In Teradata, how do we Generate Sequence?
How is MLOAD Teradata Server restarted after execution?
Define views in teradata with general syntax.
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Find 2 highest sal from each dept who have completed 5 year in org
Teradata 
