Archives of the TeradataForum
Message Posted: Mon, 10 Jun 2002 @ 19:16:32 GMT
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?
|Copyright 2016 - All Rights Reserved|
|Last Modified: 15 Jun 2023|