Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2002 @ 18:02:10 GMT

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

Matthew,

Can you load into a copy of your base table. This copy would contain only 'today's data. Would it perform adequately without the secondary indexes? At the end of the day, you copy 'Today's data into the base table.

Can you load todays data into 3 copies of the base table. Each table would have as its PI your secondary index criteria.

Jim

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