Archives of the TeradataForum
Message Posted: Wed, 18 Feb 2004 @ 21:25:38 GMT
| Subj: || || Re: Inner Join on 1=1 |
| From: || || Jason Fortenberry |
Joseph, It is doing a cross join as explained. It is joining every record of table a with every record of table b. Normally you will see
this in explain plans where the optimizer is joining 2 tables that are not explicitly joined in the query. Ummm....usually you want to avoid this
if possible. If that is your case, try defining an ON CLAUSE that defines columns to join between a and b.