Archives of the TeradataForum
Message Posted: Mon, 02 Nov 2015 @ 20:13:56 GMT
When the optimizer knows only some of the USI columns, then it must perform an *All AMP*, full scan of the secondary index, which in many cases is better than scanning the entire base table.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 24 Jul 2020|