--- In ib-support@y..., "Ann W. Harrison" <aharrison@i...> wrote:

>
> You're not going to be able to convince the optimizer to do
> something it doesn't understand and it doesn't understand
> that it can use an index to order an outer join. It may sometime,
> but it doesn't now.

I only need to know how can someone force PLAN. Is this for
future use only? I'm using stored procedures also but this
was not my question.

> Just as an aside, what do you do with the million or so records
> you get back?

I don't ever get back million records. I just would like to get
answer on how to use PLAN in select because IB or FB sometimes
doesn't use index it should. Will this improve in FB2?

Best Regards
Rado Antloga