[progress Communities] [progress Openedge Abl] Forum Post: Re: Index Reads

  • Thread starter Thread starter Tim Kuehn
  • Start date Start date
Status
Not open for further replies.
T

Tim Kuehn

Guest
Here's the before/after the customer put together. Before idxCompact After idxCompact Index Name Index Number Fields Level Blocks Size % Util Factor Blocks Size % Util Factor ix1 1513 4 3 3,440 7.0M 52.4 2 2,219 6.9M 79.8 1.4 ix2 1512 7 4 208,827 449.4M 55.5 1.9 135,009 442.4M 84.5 1.3 ix3 1514 3 3 49,513 100.6M 52.4 2 32,430 100.0M 79.5 1.4 ix4 1515 1 3 77,969 296.8M 98.1 1 74,018 281.5M 98 1 The problem index was "ix2" and the idxcompact seems to've solved the problem as there's now one index read for the CAN-FIND. One additional question I got was if there any concerns to running idxcompact for a live production database w/OE replication running.

Continue reading...
 
Status
Not open for further replies.
Back
Top