Subject Re: running SQL LIKE % on DBF table From Ivar B. Jessen <nospam@nospam.com> Date Fri, 31 Jul 2015 21:05:42 +0200 Newsgroups dbase.getting-started On Fri, 31 Jul 2015 20:10:13 +0200 Ivar B. Jessen Sender:  Ivar B. Jessen <nospam@nospam.com> wrote the following in: Newsgroup: dbase.getting-started Subject: Re: running SQL LIKE % on DBF table: MessageID:<todnra9me22cd1m6fh223kbn1elo1rt43c@4ax.com>    >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'" > Hmm, if Myname is a column name, the example should be, "select Myname from myTable where substring(Myname from 1 for 3) = 'ABC'" Ivar B. Jessen