Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8670 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 |
Which is more efficient group by or distinct to find duplicates?
What are the things to be considered while creating secondary index?
What are normalization, first normal form, second normal form and third normal form?
what are the day to day activities of teradata DBA ?
which utitility can use for loading the data from non-teradata to teradata ?
What are the multiload utility limitations?
Highlight all the modes that are present under Confidence Level.
What is the opening step in basic teradata query script?
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
What are tpump utility limitations?
how can i answer for question like teradat architecture in interveiw
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
Teradata 
