How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.

2 Answers  

---

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---

Why Fload doesn’t support multiset table?

9 Answers  

---

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

6 Answers   Wipro,

---

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,

---

suppose one Cylinder split data blocks are moved from where?

1 Answers  

---

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

---

how do you handle ET and UV errors ?

2 Answers  

---

How a Referential integrity is handled in Teradata?

5 Answers  

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

0 Answers  

---

What is called partitioned primary index (ppi)?

0 Answers  

---

What are the available primary index types in teradata.

0 Answers  

---