[progress Communities] [progress Openedge Abl] Forum Post: Re: Filter Over Multiple...

  • Thread starter Thread starter Harold-Jan Verlee
  • Start date Start date
Status
Not open for further replies.
H

Harold-Jan Verlee

Guest
I can confirm that a small test set behaves identical between situation 1 and 2. That said, I feel filter FLTR.ContractID= FLTR_CONTRACT.ContractID in situation 2, shouldn't be necessary (I know I have it reversed, but that shouldn't matter). The filter on ARTICLE is identical in both situation. The filter on FLTR is executed first but it's impact is minimal as it acts on a really small dataset (you're just defining a filter for the ARTICLE). I'll try to replicate with 100K ARTICLES in working memory to confirm this behavior.

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