Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: When to use full text indexes

Re: When to use full text indexes

From: Ken Willets <usenet_at_willets.org>
Date: 8 Jul 2003 13:55:53 -0700
Message-ID: <3d9708fe.0307081255.73004aba@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US