No, "greater that" can use either of ascending or descending index,
with no speed difference.

Ivan
http://www.volny.cz/iprenosil/interbase

----- Original Message -----
From: "Svein Erling Tysvaer" <svein.erling.tysvaer@...>


> Martijn is right, but he forgot to mention that this new index would have
> to be descending. An ascending index (default) is useful for checking less
> than something, whereas you want something greater than a set value and
> need a descending index.
>
> HTH,
> Set
>
> At 14:19 12.05.2003 +0200, you wrote:
> > > 2.
> > > Make a new field in the table which is just a calculated fields
> > > ((MyField1*100)+MyField2) and then make an index on this new field ?
> >
> >Yes.