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
- 6908 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
What are the functions performed by bynet?
Name the five phases that come under MultiLoad Utility.
How do you verify a complicated sql?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain how spool space is used.
What exactly do you know about catching in teradata?
What are the various indexes in teradata? Why are they preferred?
What are the functions of a Parser?
What is the maximum number of dml can be coded in a multiload script?
How is MLOAD Teradata Server restarted after execution?
What are the various indexes in teradata? How to use them?
What are the things to be considered while creating secondary index?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the newly developed features of Teradata?
What is the opening step in basic teradata query script?
