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
|
|