What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .

5 Answers   Accenture,

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---

When tpump is used instead of multiload?

0 Answers  

---

What is bteq utility in teradata?

0 Answers  

---

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

---

How do you create tables? Exact syntax, and create profiles, users in teradata?

0 Answers  

---

Explain fastload in teradata?

0 Answers  

---

How a Referential integrity is handled in Teradata?

5 Answers  

---

what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?

3 Answers   HCL,

---

How does indexing improve query performance?

4 Answers   Satyam,

---

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---

I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---