Answer / tdguy

As a developer, some steps(below) can be suggested.
1. look at the explain plan. check for the join types.
product joins and nested joins consume more time.
2. check for the confidence levels.
3. collect stats
4. use si, ji appropriately.
5. repeat the steps after tuning.

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

---

What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

0 Answers  

---

can I use “drop” statement in the utility “fload”?

2 Answers   Accenture, CTS, NTT Data,

---

what is identity columns in teradata

2 Answers   Wipro,

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

What is a pseudo key? What is its use???

2 Answers   Mphasis,

---

How do you do backup and recovery in teradata?

0 Answers  

---

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

1 Answers   IBM,

---

What are two examples of an OLTP environment?

4 Answers  

---

can i call router is a passive transformation

2 Answers  

---

If table have access lock.In the same table write lock is posible or not?

1 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  

---