[progress Communities] [progress Openedge Abl] Forum Post: Re: Cost-based Query Plans For Abl

[Thomas Mercer-Hursh]

One might also note that, while the idea of a completely open query environment may see attractive, in practice users are likely to actually need a more predictable subset. By providing a number of filter options and appropriate logic, one can fill a temp-table efficiently and then sort, select, combine, and compute like crazy without the disk fetch overhead. This takes some thinking and research and openness to extend, but can be highly efficient and performant with good control over formatting.

Continue reading...