Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between primary index and secondary index?.
- 2 Answers
- 8555 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 |
How do you do backup and recovery in teradata?
If table have access lock.In the same table write lock is posible or not?
How to copy 1 million records from one DB to another, Which is effective interms of performance?
Explain teradata vs. Redshift?
Highlight the differences between Primary Key and Primary Index.
How do you verify a complicated sql?
What is the difference between union and union all in teradata?
How many macros we can create inside a macro
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
What is the command in bteq to check for session settings ?
Can we collect statistics on table level?
What is spool space?
Teradata 
