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

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

tomas.kucera

Guest
Thanks all for replying! Well, I have read this many times before but always would have thought that it would choose two indexes. Now reading this many times again and again, I am getting to the point of realising that the multiple indexes are only selected if there are OR / AND in WHERE phrase. But the BY is not really included into multiple index selection unless the rule for most active sort match is applicable. Am I correct by stating this? That would mean that if there is WHERE and BY then the BY will be ignored in majority of cases and thus all these will be Client Sorted. Hmmm ... is it really so? So far all my tests seem to confirm this. My queries (simple and complex) had resolved nicely the WHERE phrase but as soon as there was both WHERE and BY involved then so far 100% of them is Client Sort: Y. :(

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