Subject Re: running SQL LIKE % on DBF table
From Ivar B. Jessen <nospam@nospam.com>
Date Fri, 31 Jul 2015 20:10:13 +0200
Newsgroups dbase.getting-started

On Fri, 31 Jul 2015 11:29:33 -0500 eric wu
Sender:  eric wu <ericwuu@hotmail.com>
wrote the following in:
Newsgroup: dbase.getting-started
Subject: running SQL LIKE % on DBF table:
MessageID:<BeKvV46yQHA.2028@ip-AC1E04A7>
  
>
>"select Myame from myTable where name like 'ABC%'"
>
>myTable.dbf is a 80MB file
>it takes 20 mins.  to get the result.
>
>is it normal ?
>
>or I should index the filed "Myame"  to improve the performance ?
>
>eric

Maybe this is faster,

"select Myame from myTable where substring(name from 1 for 3) = 'ABC'"


Ivar B. Jessen