Archives of the TeradataForum
Message Posted: Tue, 07 Aug 2012 @ 22:19:46 GMT
A NUSI is all AMP access because C, D will not be collocated with A. But if a common access path is to supply C, D values, then a single table JI with C,D as the PI will provide single amp access and answer the query from the index without access to the base table.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|