Subject Re: [firebird-support] Query doen't want to use index
Author Ann W. Harrison
adiw_db wrote:
> I ran a query to this table :
> select knokat from lib_judul where k245a like '%MATEMATIKA%'
> But it doesn't use available indexes (both fields are indexed).

Firebird can't use an index if your matching string starts with a wild
card. You'll probably find that is the case with most databases.