Archives of the TeradataForum

Message Posted: Tue, 31 Jan 2006 @ 22:22:17 GMT

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

A column is taken in consideration for SI after looking at the frequency of the use.

I have seen even after using the column that has SI in the where clause yet the Explain shows a full table scan. Hence the question of when does the optimizer think full table scan is better then using SI. I guess it is the row count.

Thanks

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