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.

Explain PDE.

1082

---

What are the various indexes in teradata?

1050

---

how do you manage the production space. what are the proactive methods you can take ?

1947

---

Differentiate database data and data warehouse data?

1116

---

What is bteq utility in teradata?

977

---

Describe the between keyword in teradata?

1040

---

List out teradata data types?

1008

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

2048

---

How do you see a ddl for an existing table?

1018

---

What is inner join and outer join?

1110

---

Explain fastload in teradata?

1108

---

Explain the term 'row' related to relational database management system?

953

---

What interface is used to connect to windows based applications?

1115

---

Explain teradata vs. Redshift?

1022

---

If RDBMS is halted what will you do ?

2168

---