quick question
SQL-92 - is this an ansi standard ?
Jeff MacDonald
[EMAIL PROTECTED]
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
> I've got a real problem with the speed of a select. Some folk might
> "SELECT * FROM data WHERE stname LIKE 'MAIN%'"
I once had a speed problem on mSQL and found if I only selected the
columns I needed, rather than use a wildcard to get them all, it ran much
faster. Of course, this is a diff
