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:
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
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:
Code:
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