Answer Posted / tdguy

i think there is no "default" join strategy. Optimizer
decides the type of strategy based on the best retrieval
path and other parameters to execute the query. Merge join
strategy, nested join strategy, hash join strategy and
product join strategies are the common strategies followed
by TD.

What is bteq utility in teradata?

933

---

Can we collect statistics on table level?

998

---

What happens when a node suffers a downfall?

1077

---

What type of indexing mechanism do we need to use for a typical data warehouse?

1106

---

Explain the advantages of partitioned primary index in a query?

990

---

What are the various indexes in teradata? How to use them?

974

---

What is stored procedure in teradata?

979

---

Can you fastexport a field, which is primary key by putting equality on that key?

1132

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2431

---

Describe the set operators in teradata.

969

---

What are types of partition primary index (ppi) in teradata?

1017

---

What are default access rights in teradata?

1070

---

How many sessions of MAX is PE capable of handling at a particular time?

1047

---

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

2429

---

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

1894

---