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
>replace
> > 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.

Regards,

Ann
www.ibphoenix.com
We have answers.