At 01:33 PM 4/01/00 -0500, you wrote:
>The table has a field called 'stname char(17)' which is indexed. The
>query is "SELECT * FROM data WHERE stname LIKE 'MAIN%'". I'm running on
>Redhat 6.1, 128MB ram, 40GB, P350. The actual index file is 4 MB.
I haven't tried it, but didn't someone mention a few weeks ago that "WHERE
stname ~ '^MAIN'" would produce the same results faster?