Answered Index Util And Factor

[BigSlick]

OE10.2BSp05 64-bit. Windows 64-bit.

Hi,

I've just finished a dump and load on a database and structured all tables and indexes appropriately. Following the changes I have re-run a dbanalys and some of the output is here:

Area Name    Area Num    Table   Index   BlkSz    Idx    Flds Lvls Blks  Size(B)  %Util  Factor
Index-Area-R8-c8    29    Table1    Index1    8192    883    1    2    3    8908.8    36.4    2.3
Index-Area-R16-c8    30    Table2    Index2    8192    87    2    2    3    8499.2    34.7    2.3
Index-Area-R64-c8    32    Table3    Index3    8192    123    2    2    3    8601.6    35.1    2.3
Index-Area-R64-c8    32    Table3    Index4    8192    124    2    2    3    8396.8    34.4    2.3
Index-Area-R64-c8    32    Table3    Index5    8192    126    2    2    3    8601.6    35.1    2.3
Index-Area-R64-c8    32    Table4    Index6    8192    805    3    2    3    8192    33.3    2.3
Index-Area-R64-c8    32    Table5    Index7    8192    923    3    2    3    8908.8    36.3    2.3
Index-Area-R128-c8    33    Table6    Index8    8192    325    2    2    3    8294.4    33.9    2.3
Index-Area-R128-c8    33    Table7    Index9    8192    951    2    2    3    8192    33.5    2.3
Index-Area-R8-c8    29    Table8    Index10    8192    340    1    2    3    9728    39.7    2.2
Index-Area-R8-c8    29    Table8    Index11    8192    342    2    2    3    9830.4    40.2    2.2
Index-Area-R8-c8    29    Table8    Index12    8192    352    1    2    3    10444.8    42.5    2.2
Index-Area-R8-c8    29    Table8    Index13    8192    358    1    2    3    9728    39.6    2.2

Progress suggests that any index with a factor of 2 or greater should be either re-built or compacted. I have done both of these following the D&L to no avail.

Are the indexes in the wrong area or am i just nit picking?

Thanks

 

[TheMadDBA]

Small indexes will almost never be perfectly compacted.

Unless you ran the idxcompact or idxbuild with packing factors I wouldn't worry about those indexes.

If you see indexes with thousands of blocks not compacted I would worry.

 

[TomBascom]

Ditto. The advice only applies to "large" indexes. 1,000 blocks is large. 3 is not.

 

[BigSlick]

Splendid. Many Thanks!