[Progress Communities] [Progress OpenEdge ABL] Separate Index Selection for WHERE and for BY

  • Thread starter Thread starter tomas.kucera
  • Start date Start date
Status
Not open for further replies.
T

tomas.kucera

Guest
The current implementation of Index Selection Rules practically excludes the BY phrase to be taken into consideration when selecting index(es). At least when developers make sure that it is the WHERE phrase that gets the attention as it limits the number of records to be read from DB. But then the sorting (BY phrase) is eliminated from index selection and all the sorting is then performed on the client.

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