Archives of the TeradataForum

Message Posted: Thu, 18 Dec 2003 @ 20:49:50 GMT

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

More on this point. If your load process allows JI's (that is, if you rae doing INSERT/SELECT into the table-Y from a stage table, or TPUMP) then you could create a Hash Index or single table JI ,either, with the BY clause specifying col-1 (AND HASH ORDERED by col-1). Although other access paths could make for different ordering and you could make this a covered index (but covered columns that get updated are a concern) to have all needed access columns in index, if you loading Table-Y with Mload (and obviously fastload)then the multi-set way might be best. Otherwise, with this idea and using mload you would need to drop and recreate the HI or STJI before the load.

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