Havasvölgyi Ottó schrieb:
> Hi,
>
> Let's assume I have a table (called tbl) with a column 'name' and an index on
> it.
> How to optimally find records whose name column begins with - say - "Pre"?
> I know it can be done with LIKE (WHERE name LIKE 'Pre%'), but will this use
> the
> index mentio
Hi,
Let's assume I have a table (called tbl) with a column 'name' and an index
on it.
How to optimally find records whose name column begins with - say - "Pre"?
I know it can be done with LIKE (WHERE name LIKE 'Pre%'), but will this use
the index mentioned above to optimize the search?
Thanks,
Ot
