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?

thank you.