On 29-9-2012 19:51, Newbie wrote:

> Is there a way to use indexes in searching for partial string in a
> field? for example table book has field Title. and is needed to search
> also partially matching Title. I made an index on title and noticed,
> when searching
>
> where title = 'keyword';
>
> the index is used OK. but when I search
>
> where title containing ('keyword');
>
> I get natural plan. Is there some way here for using an index? or maybe
> is some other way for this type searches?

These types searches cannot use an index, so a natural plan is expected.

Mark
--
Mark Rotteveel