[progress Communities] [progress Openedge Abl] Forum Post: Re: Using Matches In Where Clause

  • Thread starter Thread starter Garry Hall
  • Start date Start date
Status
Not open for further replies.
G

Garry Hall

Guest
The bracketing for the SalesRep index is not ignored. Take a look with XREF: test1.p test1.p 1 SEARCH sports2000.Customer SalesRep The search criteria has an equality match on Customer.SalesRep, so the compiler will use that. The MATCHES will never be used to provide a bracket for the compiler from which to choose the "best" index. If the only thing you have in your where clause is the MATCHES, then you are doing a WHOLE-INDEX search of the primary index, and comparing the MATCHES function for each record.

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