Subject Re: [firebird-support] Re: Slow search on a primary key index
Author Ann W. Harrison
Robin Davis wrote:
> Nope, no second index.
> Ergo, a problem with the
> search fucntion in Access I suppose. Strange, if I FILTER for the
> record, the result is as quick as iSQL.

You might try defining the second index. It's possible that
Access is looking for a user defined index and not recognizing
the system index as useful. Unlikely, but ...