Archives of the TeradataForum

Message Posted: Sat, 23 Nov 2002 @ 19:07:44 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

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.

Pat Belle
Teradata Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>