Interested to Buy Any Domain ? << Click Here >> for more details...
Hi frinds pls help me regarding this question
WHY usi is two amp operation in teradata?
THANKS IN ADVANCE....
- 3 Answers
- 7102 Views
- I also Faced
- E-Mail Answers
Answer Posted / tdguy
When an USI is created, a subtable is generated and stored.
When that USI is used in the query,TD recognizes the USI.
TD will hash the SI and the hash map will point to the
subtable in one AMP. The subtable row will point the row-id
and the row is fetched from the second amp.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
How to find duplicates in a table?
What are the design features involved in teradata?
What is spool space? Why do you get spool space errors?
Explain the new features of teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Highlight the need for Performance Tuning.
what are the day to day activities of teradata DBA ?
What are the available primary index types in teradata.
What is the opening step in basic teradata query script?
Where is teradata rdbms used?
What is the maximum number of dml can be coded in a multiload script?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are the string manipulation operators and functions associated with teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is teradata and why it is used?
