|Subject||Re: Compound Index|
> Dear Adam,Unfortunately I don't have any admin tool that reports a statistic
> Thanks for trying it in your machine. How about the RowsAffected
> statistics in your case?
>I don't have time today to upgrade my laptop to test this problem,
> I'm using FB2.0.1.
perhaps you could try 1.5 to see if this is a new issue in the 2.x
> This is much better than 28 seconds but it isIt certainly should be sub-second.
> still much higher because I expect it to be sub-second if it can
> choose the right index.
If it is indeed a 2.x issue, you could probably write a .sql script to
recreate an example database (using a stored procedure to populate
data). Post it back here to see whether anyone can fault it and if not
it should be submitted as a bug report.