Growth in index part is more than Growth in data part of table!!!! How come?

M_RAS · #1 (**permalink**) 03-17-06, 10:21

Hi All.
I am working with db2 v8.2.2 and AIX 5.2

Recently after monitoring of production database I found out in period of time for some table growthing of index is a lot larger than growthing of data in that table.

Could you please let me know how is it possible?

Thank you in advance for your help.

Peter.Vanroose · #2 (**permalink**) 03-17-06, 17:21

If you have an index on each column (or combined indices on all columns) your index storage will always be larger than your data storage, since the index stores the full column data, in addition to the index structure data and data pointers.
So even with indices on half of the columns I would expect there will be slightly more index storage than data storage.

M_RAS · #3 (**permalink**) 03-17-06, 19:42

Quote:

Originally Posted by Peter.Vanroose

If you have an index on each column (or combined indices on all columns) your index storage will always be larger than your data storage, since the index stores the full column data, in addition to the index structure data and data pointers.
So even with indices on half of the columns I would expect there will be slightly more index storage than data storage.

Thank you so much Peter.

Internet Services

Web Development

Digital Marketing

Consumer Tech