Answer / Kumar Pal Singh

Optimizing SQL in Teradata can be achieved through several methods:
1. Using appropriate indexes
2. Avoiding SELECT * FROM statements and instead specifying columns explicitly
3. Using sort-merge joins whenever possible
4. Limiting the amount of data returned by using WHERE clauses effectively
5. Minimizing the use of subqueries
6. Partitioning tables based on access patterns

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,

---

What is use of compress in terdata?Explain?

11 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

1 Answers  

---

Explain the teradata primary index mechanics in detail with a diagram.

1 Answers  

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---

Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?

1 Answers  

---

What exactly do you know about catching in teradata?

1 Answers  

---

What is SQL Assistence?please eample

4 Answers   IBM,

---

what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,

---