Indexes & Usage

[Kev]

For a given table:

Data 11.91 MB (37.76%)
Indexes 19.41 MB (61.57%)
Unused 0.21 MB (0.67%)

Total 31.53 MB
# Rows 299474

You can see that the indexes are taking up
more space than data there are a total of four
indexes on the table is shouldn't the data(MB) be
higher than the indexes(MB) ?

[jim]

The actual data for a field is stored in the index, so it can do its lookups. So it is very possible for the indexes to be larger than the table. In many cases if your indexes are setup right the data pages will not be accessed because all of the data the query needs is in the index pages.


------------
Kev at 9/5/01 3:24:12 PM


For a given table:

Data 11.91 MB (37.76%)
Indexes 19.41 MB (61.57%)
Unused 0.21 MB (0.67%)

Total 31.53 MB
# Rows 299474

You can see that the indexes are taking up
more space than data there are a total of four
indexes on the table is shouldn't the data(MB) be
higher than the indexes(MB) ?