Archives of the TeradataForum
Message Posted: Sun, 08 Aug 2004 @ 10:42:07 GMT
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
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|