http://forum.geonames.org/gforum/posts/list/4.page very very slow"]]> JForum - http://www.jforum.net oracle database. That is working fine so far. But now my problem is when I search certain entries with my select statement. To get all rows of (in this example: London) my select statement looks like this: select * from TABLE1 where NAME LIKE '% London' OR NAME LIKE 'London %' OR NAME LIKE '% London %' OR NAME = 'London' I created an index for the name column: create index my_name_idx on TABLE1(NAME); But the problem is, that the index is not used when I search with Like Therefore when I start a select statement like this one here, it took very long until I get my result. Are there any possibilities to make my search a bit faster. Maybe are there other indexes which can be used with like. Thanks for the help. Regards]]> http://forum.geonames.org/gforum/posts/list/1692.page#6968 http://forum.geonames.org/gforum/posts/list/1692.page#6968 GMT http://forum.geonames.org/gforum/posts/list/1692.page#6969 http://forum.geonames.org/gforum/posts/list/1692.page#6969 GMT http://forum.geonames.org/gforum/posts/list/1692.page#6970 http://forum.geonames.org/gforum/posts/list/1692.page#6970 GMT http://forum.geonames.org/gforum/posts/list/1692.page#6971 http://forum.geonames.org/gforum/posts/list/1692.page#6971 GMT