Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8790 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
How do you set the session mode parameters in bteq?
What is teradata?
How to eliminate product joins in a teradata sql query?
What is dimensional modeling?
What are the various indexes in teradata?
Describe the between keyword in teradata?
What is a node in teradata?
How to identify ppi columns?
In general, how do you optimze any sql in teradata?
What are some commonly used bteq scripts?
What is the difference between global temporary tables and volatile temporary tables?
What is a dimension table?
Highlight the points of differences between the database and user in Teradata.
What is the difference between fastload and multiload? Which one is faster?
In Teradata, what is the significance of UPSERT command?
