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 does sleep function does in fast load?

1065

---

any one answer me how they can analyzing the project using data ware housing?

2407

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1059

---

What are the commands to make a new table, change a table and remove a table in teradata?

1066

---

What is a dimension table?

981

---

Explain the term 'primary key' related to relational database management system?

979

---

Explain teradata architecture?

1031

---

What is stored procedure in teradata?

956

---

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

1086

---

How do you set the session mode parameters in bteq?

1032

---

What is node? How many nodes and amps used in your previous project?

1061

---

How do you define Teradata?

982

---

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

1962

---

what is sysdba and sysdbc ? which has high priority ?

3759

---

List out some of the primary characteristics of teradata.

925

---