jim-watters_at_rogers.com (Jim) wrote in message news:<93f2172.0307040933.433ba646_at_posting.google.com>...
> 1. What are the critieria that would justify a full text index?
> 2. When are the limitations of LIKE based queries?
>
LIKE is generally implemented as a filter, sort of like grepping all
the fields in the DB. FT indexing, as it currently stands, would make
it more efficient to select the records matching the pattern desired,
provided the pattern contains whole words.
Received on Tue Jul 08 2003 - 15:55:53 CDT
