Archives of the TeradataForum
Message Posted: Fri, 14 Mar 2008 @ 12:39:16 GMT
The table "PM_EDW_MSTR_D.d_ORGANIZATION" is a part of some cluster with the common column as PM_EDW_MSTR_D.d_ORGANIZATION.ORG_ID, whereas the table containing PARTY_ID as the primary index column will not be a part of the same cluster.
So, it could take a longer time to retrieve values for PM_EDW_MSTR_D.d_ORGANIZATION.ORG_ID.
Is this understanding correct?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|