Thanks for the correction.

I'm going to have to invert a couple of indeces and see how much of a
difference it makes for my app.

On Sat, 2004-11-20 at 13:52, Ann W. Harrison wrote:
>
> At 07:23 PM 11/19/2004, David Johnson wrote:
>
> >For better performance, you would typically put the more unique value
> >first in the index, then the less unique.
>
> Not in Firebird. Our indexes use prefix compression so duplicate
> leading values aren't represented in the stored key. For best
> compression, the keys should be ordered from least to most selective.
> Best compression leads to the fastest lookup because it minimizes
> the need to read index pages.