Archives of the TeradataForum

Message Posted: Fri, 12 Sep 2003 @ 17:45:03 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

If you read the entire text of my first reply, I apologize that you were confused by the statement regarding the optimizer's decision on whether to use a secondary index. This, as stated does not apply to SPOOL and therefore applies to permanent and global temp tables only.

The other part of my original reply indicated that a derived table is materialized in SPOOL. Therefore, you are correct in that Teradata will not use a secondary index for any access of a derived table, because there are no secondary index definitions in SPOOL.

Best regards always,

Michael Larkins
Certified Teradata Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>