Archives of the TeradataForum

Message Posted: Tue, 19 Oct 2010 @ 15:55:26 GMT

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

Yes, secondary indexes are used. Like with statistics, you need to carefully evaluate the performance gains vs. the increase to the ETL process.

This is usually an easy decision if adding a minute to your load time saves time over the execution of hundreds of queries.

Dave

David W. Roth
Teradata Certified Master
TERADATA

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