Archives of the TeradataForum
Message Posted: Tue, 11 Jun 2002 @ 20:40:33 GMT
Teradata will only use an index during the process of reading rows. It only uses an index for a join when it is a nested join. All other joins normally involve one or more SPOOL files and primarily uses a merge join.
So, as far as the actual join processing goes from SPOOL, Teradata never uses an index.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|