Hi,

At April 15, 2003, 05:33, Tim Ledgerwood wrote:

> I am having to write my own query plans for many of my queries and stored
> procedures, as I am finding that the optimizer generally chooses the wrong
> indices.

> Any hints on this?

Which version are you using? The optimizer has been improved in
Firebird 1.5.

--
Best regards,
Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.filopto.com)