[progress Communities] [progress Openedge Abl] Forum Post: Re: Where's My Query Resolved?

[OctavioOlguin]

Investigating, this code is not the culprit.... it is: for each table where field1 <= dateX and field2 <= dateY and field3 = "somevalue": .... end. and have at best those indexes: A (field1) B (fiedl2) C (another-field, field3) . So found out there is no suitable bracketing on this matter ... Considering index D (Field3, Field1, Field2)... What you say??? Thanks...

Continue reading...