Archives of the TeradataForum

Message Posted: Fri, 30 Apr 2004 @ 12:40:59 GMT

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

Prabhjot,

A SI is said to be covered when your query selects only those columns that are defined on the SI. That way only SI sub-table row is read and the request satisfied withput reading the base table table row.

The explaination is somewhere in one of the manuals that discusses all the INDEX choices.

Hope that helps

Raghav

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