[progress Communities] [progress Openedge Abl] Forum Post: Re: Dynamic Queries With Where,...

  • Thread starter Thread starter WJCPvanBeek
  • Start date Start date
Status
Not open for further replies.
W

WJCPvanBeek

Guest
That is correct Tomas. In your case where you have salesrep in the where and name in the BY, progress uses the alesrep index to select a number of rowid's that conform to the where clause. After that these rowid's are sorted using the BY, So if you have a BY you double the number of database reads.

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