Subject Re: [firebird-support] Indexing for Min and Max
Author Nando Dessena
David,

d> KnowledgeBase Id: 295 seems to indicate that a bug was fixed back in
d> Intebase V5.x whereby the optimizer wouldn't use an index for min and max.

Yep.

d> I am seeing it on Firebird 1.5 though! The article suggests telling the
d> optimizer which index to use - should I do this?

Are you aware that you need an ascending index for min() and a
descending index for max()?

If this does not help, then please post metadata, query and resulting
plan for the situation you are observing.

Ciao
--
Nando mailto:nandod@...