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

  • Thread starter Thread starter Jeff Ledbetter
  • Start date Start date
Status
Not open for further replies.
J

Jeff Ledbetter

Guest
Hi. The help for the MATCHES statement states: "MATCHES does not use index information when performing a comparison; it always scans the entire data table." Does this mean that if a MATCHES operator is present, all bracketing that may occur from other entries in the WHERE clause is ignored and a table-scan is performed? For example, will this MATCHES cause the bracketing on SalesRep to be ignored? FOR EACH Customer NO-LOCK WHERE Customer.SalesRep = "bob" AND Customer.Name MATCHES c: END.

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