| Subject | running SQL LIKE % on DBF table |
| From | eric wu <ericwuu@hotmail.com> |
| Date | Fri, 31 Jul 2015 11:29:33 -0500 |
| Newsgroups | dbase.getting-started |
"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 | |