> In my last conversation with Jason about this subject,
> he mentioned that IBOjects generated the PLANS, and
> how we should fool IB6 to closely match them. Has
> become a 'gray' are to me now, who is doing what :)

Hi Hans,

AFAIK IBO just retrieves the plan information it does not "generate"
them. So if IB6 is using the correct plans (and giving good
performance) then we would need to see if IBO is printing the wrong
information. But if IB6 is performing badly that would indicate that
IBO is reporting the correct (bad) plans.

Given the simplicity of the statement I cannot think of anyway to
force IB to generate a particular plan. I have seen reference
recently to a bug in IB6 where it is possible in some (rare?)
situations to end up with two primary keys - the result of which
neither is used for optimisation.

Have you tried setting up a demonstration in a separate database to
make sure that you are not being impacted by such possibilities?

Geoff Worboys
Telesis Computing