Archives of the TeradataForum
Message Posted: Tue, 04 Feb 2004 @ 00:21:32 GMT
| Subj: || || Re: Query Performance |
| From: || || Christie, Jon |
I suspect the main thing that is wrong with the original plan is that there were a bunch of terms on the right table in the nested join and
they could not be applied until the following rowid join step. The actuall size of the spool that's the result of the nested join is much larger
The optimizer used to fall into this trap all the time in release 4, but in release 5 it's much smarter - at least on this issue. What release
are we running here? I don't think it was mentioned.