| Subject | Re: [firebird-support] Query doen't want to use index |
|---|---|
| Author | Ann W. Harrison |
| Post date | 2005-01-18T17:09:36Z |
adiw_db wrote:
card. You'll probably find that is the case with most databases.
Regards,
Ann
>Firebird can't use an index if your matching string starts with a wild
> 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).
card. You'll probably find that is the case with most databases.
Regards,
Ann