Answer Posted / veni botcha

JOIN INDEX:
-----------

Join Index is nothing but pre-joining 2 or more tables or
views which are commonly joined in order to reduce the
joining overhead.
So teradata uses the join index instead of resolving the
joins in the participating base tables.
They increase the efficiency and performance of join queries.
They can have different primary indexes than the base tables
and also are automatically updated as and when the base rows
are updated. they can have repeating values.

There are 3 types of join indexes:
1)Single table join index - here the rows are distributed
based on the foreign key hash value of the base table.
2) Multi table join index - joining two tables.
3) Aggregate join index - performing the aggregates but only
sum and count.

What are the 5 phases in a multiload utility?

981

---

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

952

---

Discuss the advantages of using partitioned primary index in a query?

903

---

What is teradata? What are some primary characteristics of teradata?

926

---

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

1150

---

How do you do backup and recovery in teradata?

960

---

Steps to create a data model?

1060

---

What's the difference between timestamp (0) and timestamp (6)?

1120

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

924

---

What is the purpose of indexes?

1009

---

Difference between multiload and tpump?

1038

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

1723

---

what is sysdba and sysdbc ? which has high priority ?

3759

---

How do you verify a complicated sql?

1011

---

What is bteq utility in teradata?

914

---