![]() |
Hello,
28 Sep 2012
| 6 comments
,
|
![]() |
Hi am new to Teradata and am stuck with a problem
There is an ID table which stores an Unique ID given to each person
13 May 2012
| 5 comments
,
|
![]() |
I have read somewhere that Not exist will almost always perform better than Left join with null check in where clause,Can someone tell me the reason for this ? eg : SEL A.* FROM TABLE A WHERE NOT EXISTS (SEL 1 FROM TABLE B WHERE A.KEY=B.KEY ) Would perform better than
30 Nov 2011
| 4 comments
,
|
![]() |
There are three SQL statements (a, b & c) below, each of which performs a left join. Can anyone please explain how the execution of these statements differs from the other? a) select c.c_name, a.n_name
14 Jun 2010
| 1 comment
,
|