Interested to Buy Any Domain ? << Click Here >> for more details...
sel a.t1,b.t1 from emp a left outer join dept b ON
a.id=b.id where b.deptno=10;
sel a.t1,b.t1 from emp a left outer join dept b ON
a.id=b.id and b.deptno=10;
what is the difference on the above 2 queries?
- 3 Answers
- 10417 Views
- CTS, I also Faced
- E-Mail Answers
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
".
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the string manipulation operators and functions associated with teradata?
What's the difference between timestamp (0) and timestamp (6)?
What is primary index and secondary index?
What do you mean by teradata sql assistant?
What is meant by a Highest Cost Plan?
what is object level locking ? where do appear this type of locking ?
What is partitioned primary index (ppi)?
What are the functions involved in shared information architecture?
What is a sparse index?
What is logical data model?
How will you solve the problem that occurs during update?
How many codd's rules are satisfied by teradata database?
In general, how do you optimze any sql in teradata?
Can we collect statistics on multiple columns?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
