Archives of the TeradataForum
Message Posted: Sat, 23 Nov 2002 @ 19:07:44 GMT
Stephen is correct if the query is covered by the index. The query will be serviced by a "full table scan" of the index sub-table in that case. However fully covering NUSI's have been the exception in the queries that I've seen.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|