Answer Posted / tdguy

This is a good question. If we look at the explain plans,we
would be able to understand the difference.
1. In the first query, the condition given in where clause
is applied after the left outer join process on the tables.
This means that it is a plain left outer jon on id column
between the tables and the where condition is applied after
the join process. This can be seen in the explain plan as
"by way of a RowHash match scan with a condition".
2. In the second query, the condition given in and
statement clause is applied along with the left outer join
process on the tables. This means that it is a left outer
jon on id column between the tables with table b with only
one row. This can be seen in the explain plan as
"by way of a RowHash match scan with no residual conditions
".

Highlight the need for Performance Tuning.

1087

---

Difference between inner join and outer join?

1002

---

What does Amp contain and what are all the operations that it performs?

990

---

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

1061

---

Steps to create a data model?

1104

---

Explain the meaning of Amp?

1115

---

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1150

---

What are the different softwares used with their functions in teradata?

997

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1082

---

Can we collect statistics on multiple columns?

1040

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

983

---

What is primary index and secondary index?

1010

---

Explain amp in teradata?

1058

---

What are the components used in smp and massively parallel processing (mpp) machines?

1042

---

What is the difference between teradata and oracle?

1003

---