Archives of the TeradataForum
Message Posted: Thu, 29 Jun 2006 @ 18:03:55 GMT
The base difference between merge and hash join is that the rows need to be sorted in hash order for merge join. Again based on the cost, one of these joins is picked up.
The answer to the exec function failure is due to the access rights. If the user (role) does not have the privileges on syslib, that user can not execute any function from syslib.
|Copyright 2012 - All Rights Reserved|
|Last Modified: 21 Mar 2013|