Answer Posted / praveen

By creating index on single or multiple columns, query
takes index access path instead of full table scan. Full
table scan is costilier operation where it has to visit all
rows in the table whereas index operation just accesses the
index sub table with required hash value and joins with the
basetable using rowid. This improves response time and
performance of the query.

What is the maximum number of dml can be coded in a multiload script?

1098

---

In BTEQ, how are the session-mode parameters being set?

1140

---

What is the multi-insert?

1026

---

how many modules are there in telecome domain?how to explain the architecture?

2013

---

How to find duplicates in a table?

1204

---

What are the main components of teradata system?

1122

---

Mention a few of the ETL tools that come under Teradata.

1072

---

What are the advantages of teradata?

1006

---

what is object level locking ? where do appear this type of locking ?

3490

---

What are different table types used in teradata?

1032

---

What are the updated features of teradata?

1038

---

How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4364

---

Where is teradata rdbms used?

1088

---

if collect stats but it show low confidence why?

1678

---

Explain some differences between mpp and smp?

1090

---