Difference in Index sizes in DB02

[ken_halvorsen2]

Can anyone explain why there is a difference in the index size in the transaction DB02.

For example when I look up the table FKKMAZE in transaction DB02 > Space > Single Table Analysis, in the Indexes tab it shows me 4 indexes totaling about 273,000,000 KB.

But when I look at the table from DB02 > Space > History > Table Size History it shows the total index size to be 136,000,000.

[former_member184473 · Accepted solution]

Hello,

What is the information which appears in the DB02 -> Single table analysis in the following fields?

Reserved size (KB)

Data size (KB)

Index size (KB)

Unused size (KB)

It has any differences in the history tab?

Regards,

Eduardo Rezende

[ken_halvorsen2 · Accepted solution]

For the above example on Table FKKMAZE:

Transaction DB02 -> Single table analysis -> Overview tab:

Reserved size (KB) 289,592,920

[former_member184473 · Accepted solution]

And the information about the data, index and unused sizes?

Is there any differences between these data?

The time collection for the two tab are the same?

Regards,

Eduardo

[ken_halvorsen2 · Accepted solution]

Sorry Eduadro

Not sure what happened to the rest of the answer?

for Table FKKMAZE in the Overview tab:

Reserved size (KB) 289,592,920

Data size (KB) 143,468,440

Index size (KB) 136,250,336

Unused size (KB) 9,874,144

In the History > Table Size History the entries for FKKMAZE are the same. And time frame would be the same.

But in the Single Table Analysis > Indexes tab for table FKKMAZE there are 4 Index names

Size (KB) Reserved Used

FKKMAZE~0 143,468,440 289,592,920 279,718,776

FKKMAZE~001 36,649,528 37,910,880 37,458,416

FKKMAZE~002 34,821,016 35,660,880 35,479,160

FKKMAZE~003 57,924,452 67,996,584 59,409,720

[former_member184473 · Accepted solution]

Hello,

The information which appears in the data field is the size of the primary index (~0).

The primary index and the data are located in the same pages in your file. Microsoft did this way.

The information which appears in the index size is the sum of all other indexes you've in this table.

So, I think the information in the two tabs (Single Table Analysis and Table Size History) are correct.

Regards,

Eduardo

[ken_halvorsen2 · Accepted solution]

Thanks

It is a little confussing though isn't it. I was expecting the Index size to be, well, the size of the indexes?