need help with an index!

microsoft.public.sqlserver.programming

15 Jul 2005 4:39 PM

=== Steve L ===

i'm using sql2k.

one of the table i'm working with has book title field in in. the max
lengh is 1800 (varchar). i need to index on the title for search
performance but the max index key lenght for sql is 900 bytes. what can
i do?

thank you

15 Jul 2005 4:50 PM

Alejandro Mesa

Use full-text search service.

AMB

Show quote

"=== Steve L ===" wrote:

> i'm using sql2k.
>
> one of the table i'm working with has book title field in in. the max
> lengh is 1800 (varchar). i need to index on the title for search
> performance but the max index key lenght for sql is 900 bytes. what can
> i do?
>
> thank you
>
>