Sudheer Palaparambil wrote:

>Hi,
>
> Can somebody tell me how to speed up search on a book title column
>(varchar(100)), the user will be usually entering first 2 or 3 words of the
>title. What I am using now is LIKE, but this is very slow on a table which
>contains 120000+ records.
>
> Any suggestion are greatly appreciated.
>
> Thank you.
>
>Sudheer
>
>
>
>Yahoo! Groups Links
>
>
>
>
>
>
>
>
>

try using STARTING WITH.
sdh