Subject Re: [firebird-support] Re: Slow search on a primary key index
Author Robin Davis

Ann W. Harrison wrote:
> For reasons I don't quite understand, Access is asking for
> the whole table and doing the filtering locally, unless you
> specify FILTER or WHOLE FIELD.
My FDB uses win1252 collation so I can have lower case searches on
various varchar fields. They all work superbly except for the primary
key. Why is that? I can get round the problem but I don't understand.
Based on the above I would have thought I'd be getting grief on all fields.


Rob Davis