Archives of the TeradataForum

Message Posted: Sun, 08 Aug 2004 @ 10:42:07 GMT

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

Hi All,

Recently I faced question like

1) How to make out whether optimizer has used a join index if it exists, using the Explain outputs or whether it uses a secondary index or primary index, or hash index?

2) can we guarantee the use of a index for a particular type of sql?

3) What happens if a mload script happens to load duplicate row in the target table? And how can we come out of such situations

MKM

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