 |
 |
Archives of the TeradataForum
Message Posted: Fri, 26 Oct 2001 @ 19:37:59 GMT
| Subj: | | Re: Execution Plans for ANSI vs non_ANSI formatted SQL |
| |
| From: | | Fred Pluebell |
Mixing qualified and unqualified references to the same table (and particularly to the same column as in your examples) should be
avoided. Try this instead:
explain locking row for access
select a.databaseid, b.tableid, b.fieldid
from
DBC.TVM a
join
dbc.tvfields b
on (b.tableid = a.tvmid)
where
b.tableid = '000000090000'xb ;
explain locking row for access
select a.databaseid, b.tableid, b.fieldid
from
DBC.TVM a,
dbc.tvfields b
where
b.tableid = a.tvmid
and b.tableid = '000000090000'xb ;
| |
