Subject Re: [ib-support] Query Plans
Author Tim Ledgerwood
Thanks Darren.

I am a bit hesitant to use 1.5, (or any Beta product) because the Delphi
app that uses the DB is mission critical to the clients, and the clients
(i.e., the sites where each stand - alone app is installed and being used)
are widely distributed across South Africa, making even small changes
difficult and expensive.

Regards

Tim

At 05:58 AM 4/16/2003 -0300, you wrote:

>Hi,
>
>At April 16, 2003, 01:37, Tim Ledgerwood wrote:
>
> > Still looking for some help on Query Plans.
>
> > I would like to know why some indices cannot be used in a query plan.
>
>It all comes down to the "selectivity" of the indices. And, as I stated
>before, Firebird 1.5 has a better query optimizer. Try Firebird 1.5,
>and if you still feel that some plans are not correct, then you can
>post your question, along with your table structure, your query and
>the generated plan(and maybe the plan that you think it should be).
>
>--
>Best regards,
> Daniel Rail
> Senior System Engineer
> ACCRA Group Inc. (www.accra.ca)
> ACCRA Med Software Inc. (www.filopto.com)
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>---
>Incoming mail is certified Virus Free.
>Checked by AVG anti-virus system (http://www.grisoft.com).
>Version: 6.0.470 / Virus Database: 268 - Release Date: 4/8/2003


[Non-text portions of this message have been removed]