Archives of the TeradataForum

Message Posted: Mon, 10 Jun 2002 @ 19:16:32 GMT

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

All,

Suppose I have 2 tables which consist of the same records. Table A has no secondary indexes. Table B has 1 or more secondary indexes. It is my understanding that a full-table scan of table A would be faster than a full-table scan of table B (because Table A requires less diskspace.)

Why should the existence of secondary index sub-tables factor into the amount of time it takes to scan a dataset?

Thanks,

Claybourne Barrineau

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