Archives of the TeradataForum

Message Posted: Mon, 24 Mar 2003 @ 22:13:33 GMT

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

In addition,

For #1, If you force the join to a reference table and do the range condition on the reference table, these will be resolved during the scan of the reference table and the values used to restrict any larger table via a normal Secondary or Primary Index.

God Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.

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