Subject | Re: [firebird-support] Indexing for Min and Max |
---|---|
Author | Nando Dessena |
Post date | 2003-10-09T18:34:03Z |
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@...
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@...