|
|
Archives of the TeradataForum
Message Posted: Tue, 11 Jun 2002 @ 01:10:08 GMT
Subj: | | Re: Full-Table Scans and Secondary Indexes |
|
From: | | David Wellman |
Claybourne,
If you're talking about a full-table scan (FTS) the existence of si's of any sort is irrelevant. By definition, an FTS doesn't use an
index, it simply scans the data. As has been pointed out, the SI rows are in physically different blocks on disk and so are not referenced
during an FTS operation.
Cheers,
Dave
Ward Analytics Ltd: Information in motion (www.ward-analytics.com)
| |