Archives of the TeradataForum
Message Posted: Wed, 16 Dec 2015 @ 20:57:03 GMT
| Subj: || || Re: Why there is a USI restriction on Join Indexes. |
| From: || || Anomy Anom |
<-- Anonymously Posted: Wednesday, December 16, 2015 17:09 -->
USI on JI is not allowed simply to keep index maintenance overhead more manageable.
NUSI is AMP-local so no need to separately journal data value changes for the index - if the AMP rolls back a base table row, then it already
has the information needed to also roll back any corresponding NUSI change.