[progress Communities] [progress Openedge Abl] Forum Post: Re: Binary Dump And Load -...

[Thomas Mercer-Hursh]

Yes, Gus and George, I understand that traversing the entire file according to a specified index, that there is a significant advantage to having the table be in physical order matching that index. My question relates to my expectation that this is a rare requirement, at least in a version modern enough to have table-scan. Most queries are going to be either individual records or a group of records bracketed on any one of several indices which are unlikely to match physical order. Fragmentation is a separate issue.

Continue reading...