At 22/03/2002 03:56 PM, you wrote:

>When I click the prepare button a plan is returned. I must click in the
>prepare all the times that I want to configure the ib_query? Why is the
>plan?

The plan is generated by the IB and FB query optimizer. The plan helps in
optimizing your query. It tells you which indexes that the query is using
and helps you decide which index that you could create and would benefit in
the performance of a query. If you don't specify a plan, then IB/FB will
generate it. I never did specify a plan explicitly, I let FB do the work
and check the returned plan to see how I can optimize the query. That
doesn't mean that I didn't try it before, I was never successful in
creating a valid plan and now I prefer the server does it.


Daniel Rail
Senior System Engineer
ACCRA Group Inc. (www.accra.ca)
ACCRA Med Software Inc. (www.accramed.ca)