G
gus
Guest
> On Feb 11, 2016, at 2:15 PM, dbeavon wrote: > > SQL92 is already available and the SQL language is a more standardized approach for declaring result sets that can benefit from advanced cost-based optimization techniques. No point reinventing this wheel in ABL. this is exactly what /must/ be reinvented if you want cost-based query optimization in the 4GL. there is almost no overlap. query optimizers are very much like optimizers in language compilers. there are a few general principles or common techniques that can be used to get maybe 20 % and then the remaining 80% is a bunch of special cases that are specific to the details of the query expression and the data types involved.
Continue reading...
Continue reading...