At 06:46 AM 5/10/2012, Rohit Gupta wrote:

>Its not necessary to add a plan, the firebird engine is pretty good at
>selecting the best one. Many years ago I remember reading that you can
>suggest a plan, but the engine might use what it wants. :-) I dont
>know if its true, but it was in of the documents.

It's not true. If you specify your own plan, the engine will not even consider using its own plan...to such an extent that, if the user-supplied plan is invalid, the engine does not try to fix it; it rejects the request with an exception.

Helen