[Progress Communities] [Progress OpenEdge ABL] Forum Post: RE: Surprising performance inconsistency (adding index)

  • Thread starter George Potemkin
  • Start date
Status
Not open for further replies.
G

George Potemkin

Guest
To advocate Progress: idxbuild can use the methods that only work if data are not changing. Would you agree to use online idxbuild that locks the whole table while the utility is building one of table’s indexes? The ones who complain about slow online index build are ignoring their duty to check periodically index health. Otherwise you would complain about slow index check. The one of our customers with large database was recently tried to run the option 1 of idxfix (scan records for missing index entries) for only one index. The estimated time to complete the scan was 16 years. They did not try to use the option 2 (scan indexes for invalid index entries) – it could take the hundreds of years. What could they do when they will face the critical index corruption but they will not have the full list of the records with the missed index keys? What could they do when they will get at least one (just one!) invalid index key? Only to run offline idxbuild. For their data it would take one or more days and it’s, or course, absolutely not acceptable for their business.

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