Archives of the TeradataForum

Message Posted: Thu, 06 Jul 2006 @ 17:46:57 GMT

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

Join Indexes are picked up based on costing by optimizer. Optimizer picks up a join index as either a covered join index or a partial covering index. The second one depends on the cost to join back to the table. You need to analyze your workload for joining conditions and go for appropriate join index. As mentioned in other threads, there is a conflict with load utilities like mload and fastload on the tables with join index. You need to consider your ETL process before going for any JI.

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