Hi,

Nope, didn't know that. But I am using a primary key - is an index
required too?

Cheers,

David




Nando Dessena <nandod@...> on 09/10/2003 02:34:03 PM

Please respond to firebird-support@yahoogroups.com

To: firebird-support@yahoogroups.com
cc:
Subject: Re: [firebird-support] Indexing for Min and Max


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@...



To unsubscribe from this group, send an email to:
firebird-support-unsubscribe@yahoogroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/