Subject Re: [ib-support] Select count(*) slow even with index?
Author Ann W. Harrison
At 12:46 PM 3/19/2002 +0100, Georg Schäfer wrote:
>Helen wrote:
> >
> > Probably not. You would likely be better to remove that index and
> > it with one on (FOLDER_ID,PRI_KEY) to improve the selectivity.
>Of course, that would improve selectivity. But would it change the amount
>of work for the engine to do?

Not particularly.


We have answers.