Index on FAGL_SPLINFO_VAL is larger than the table

Hi

The index on FAGL_SPLINFO_VAL is about 30GB larger than the table, however the index contains 2 columns less than the table. We are running DB2 V9.1, however have only just migrated from DB2 8.2. Can anyone explain why this index would be so much larger than the table - the table is 167GB and the index is 200GB.

Thanks

Leigh White

SAP Basis Administrator