Answer / 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.

Answer / nitin bansal

Generally the Parsing Engine preapres a two amp plan for
USI, as in case of USI there will be a subtable which has
the hashed value of the USI and the ROW ID of the Primary
Index. So when you search using the USI first it will go to
the AMP which has the subtable and then using the ROW id
from the subtable it will go to the AMP where the actual
row resides.

In a case where the PI and USI value are same it can be a
one amp operation as the HASHED value of oth the PI and USI
will go to the same AMP.

Answer / gowthami

Thanks alot nitin for ur rly.

i would like share 1 interview question which was asked in
ibm.

Q)there are two rows like aa6588fhfhf,gru282vbvv.
Question is howcan we retrive the first number from two
rows.

thanks in advance

How to select first n records in teradata?

0 Answers  

---

What is meant by a Highest Cost Plan?

0 Answers  

---

what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

0 Answers  

---

What are the different functions performed in development phase?

0 Answers  

---

Highlight all the modes that are present under Confidence Level.

0 Answers  

---

How is Teradata in current market?

4 Answers  

---

Can we collect statistics on table level?

0 Answers  

---

What are two examples of an OLTP environment?

4 Answers  

---

Why AMP & PE are called Vprocs?

4 Answers  

---

What is the purpose of indexes?

0 Answers  

---

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,

---