Thanks for your answer Thomas. I think in the case I had in mind I
would do better with a generator.

Anyways, is it possible to have both, an ascending and a descending
index on the same column? Will disk storage for these indexes
duplicate?

--- In ib-support@y..., "Thomas Steinmaurer" <ts@i...> wrote:
> Daniel,
>
> I have only one simple answer (don't know about your other
> questions). Create an DESCENDING index on your column and
> MAX() will be significantly faster, whereas an ASCENDING
> index speeds up MIN().
>
>
> Regards,
> Thomas Steinmaurer
> IB LogManager 2.1 - The Logging/Auditing Tool for InterBase and
Firebird
> http://www.iblogmanager.com
>
> > I have an indexed column where a simple "SELECT MAX(<column>)
FROM
> > <table>" generates a full table scan. I guess it has to do with
the
> > index compresion stuff I read somewhere. This particular table
has
> > over 1.5 million records (the database has plenty of super
populated
> > tables).
> >
> > Should I create an ascending AND a descending index to obtain
decent
> > perfomance? What about storage... will it duplicate?
> >
> > BTW, how does index compression affect negatively on geographic
> > coordinates (lat/lon, UTM)? If there is a problem, is there any
> > workaround (perhaps storing hours, minutes, seconds instead of
> > decimal notation?).
> >
> > TIA.
> >
> > Greeting,
> > Daniel Berstein
> >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@e...
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >